stuzer05 revised this gist 3 hours ago. Go to revision
1 file changed, 19 insertions
script.sql(file created)
| @@ -0,0 +1,19 @@ | |||
| 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; | |
Newer
Older