script.sql
· 559 B · MySQL
Raw
select owner as schema_name,
job_name,
job_style,
case when job_type is null
then 'PROGRAM'
else job_type end as job_type,
case when job_type is null
then program_name
else job_action end as job_action,
start_date,
case when repeat_interval is null
then schedule_name
else repeat_interval end as schedule,
last_start_date,
next_run_date,
state
from sys.all_scheduler_jobs
order by owner,
job_name;
| 1 | select owner as schema_name, |
| 2 | job_name, |
| 3 | job_style, |
| 4 | case when job_type is null |
| 5 | then 'PROGRAM' |
| 6 | else job_type end as job_type, |
| 7 | case when job_type is null |
| 8 | then program_name |
| 9 | else job_action end as job_action, |
| 10 | start_date, |
| 11 | case when repeat_interval is null |
| 12 | then schedule_name |
| 13 | else repeat_interval end as schedule, |
| 14 | last_start_date, |
| 15 | next_run_date, |
| 16 | state |
| 17 | from sys.all_scheduler_jobs |
| 18 | order by owner, |
| 19 | job_name; |