This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing one DBA helpful script to find the status and schedule information of SQL Server Agent JOB.
Using SSMS, We can also find this information, but working with the script is always better.
As we are Database Administrator, we are also responsible for reporting of different type of database objects.
We can use below script to report important information about the SQL Server Agent JOB.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
USE msdb GO SELECT SJ.name AS JobName ,CASE WHEN SJ.enabled = 1 THEN 'Enable' ELSE 'Disable' END AS JobStatus ,SJ.description AS JobDescription ,SS.name AS JobScheduleName ,CASE WHEN SS.enabled = 1 THEN 'Enable' WHEN SS.enabled = 0 THEN 'Disable' ELSE 'Not Schedule' END AS JobScheduleStatus ,SS.active_start_date AS ActiveStartDate ,SS.active_end_date AS ActiveEndDate ,SS.active_start_time AS ActiveStartTime ,SS.active_end_time AS ActiveEndTime FROM dbo.sysjobs AS SJ LEFT JOIN dbo.sysjobschedules AS SJS ON SJ.job_id = SJS.job_id LEFT JOIN dbo.sysschedules AS SS ON SJS.schedule_id = SS.schedule_id GO |
