getScheduledJobs
Syntax
getScheduledJobs([jobIdPattern])
Arguments
jobIdPattern is a string indicating a job ID or a pattern of job ID. It supports wildcard characters (% and ?).
Details
Return a table of scheduled jobs. If jobIdPattern is not specified, return all scheduled jobs.
It returns a table with the following columns:
Name | Meaning |
---|---|
userId | the user ID |
jobId | the job ID |
jobDesc | the job description |
startDate | the start date of the scheduled job (of DATE type) |
endDate | the end date of the scheduled job (of DATE type) |
frequency | the frequency to execute the scheduled job |
scheduledTime | the specified time to execute each job (of MINUTE type) |
days | the specified days to execute the scheduled job when frequency is 'W' or 'M'. |
Examples
getScheduledJobs();
userId | jobId | jobDesc | startDate | endDate | frequency | scheduleTime | days |
---|---|---|---|---|---|---|---|
root | monthly | Monthly Job | 2018.01.01 | 2018.12.31 | M | 17:00m | 1 |
root | weekly | Weekly Job | 2018.01.01 | 2018.12.31 | W | 17:30m | 2 |
root | daily | Daily Job | 2018.01.01 | 2018.12.31 | D | 18:00m |