SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Agent Job Schedule Description

By Michael McCormick,

Of all the Agent Job Schedule Description scripts out there, this is another one. This sprang from a request for a report of all Agent Jobs and their schedules. I had a strong desire to make the descriptions grammatically correct, and found several scripts that were close, but not completely what I was looking for.

I would like to acknowledge the contributions of two particular scripters upon which this script is founded upon. Ken Simmons, who revealed the existence of the sp_get_schedule_description procedure and exposed the code within, and Michelle Ufford, who had the idea of using the code as a CTE query for the overall job list query, and provided the basic structure of that query.

For my part, I finished out the query with all schedule types available in SQL Server 2012, added some grammatical changes that I thought were important, and added another CTE with job history information.

Please enjoy!

Total article views: 634 | Views in the last 30 days: 4
Related Articles

Generate Job Schedule Descriptions

A SELECT statement which includes the alpha description of each job's schedule


get schedule description

workaround the bug in msdb..sp_get_schedule_description


Script for SQL Job Schedule Details

Script for SQL Job Schedule Details


Scheduling a PowerShell Script Using SQL Server Agent

This article will give you insight to understand how you can schedule a powershell script you have w...


Get Error Description in SQL Server 2000

How to Extract Error Description in SQL Server 2000 based on Error Number

sql server