Agent Schedules
Published Mar 23 2019 11:32 AM 303 Views
First published on TECHNET on Jun 28, 2010

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 .


Version history
Last update:
‎Mar 23 2019 11:32 AM
Updated by: