Agent Schedules

Published Mar 23 2019 11:32 AM 137 Views
Microsoft
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 http://www.mssqltips.com/tip.asp?tip=1622 .






List_Scheduled_Activity.sql

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