Partilhar via


Agent Schedules

The SQL Server Management Studio has a "Job Activity Monitor" which provides a lot of useful information about scheduled jobs. However, it does not show the schedule type or a schedule description, nor does it clearly distinguish between the job being enabled vs. the schedule being enabled. The query in the attached file provides that extra info, which can be very useful. It requires the udf_schedule_description user defined function (UDF) from https://www.mssqltips.com/tip.asp?tip=1622.

List_Scheduled_Activity.sql