Click here to monitor SSC
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)

Generate Job Schedule Descriptions

By Richard Sutherland,

Microsoft doesn't provide a way toSELECT the job schedule descriptions. They do
provide a stored procedure[msdb.dbo.sp_get_schedule_description] which will return
a job schedule description for one job.

This script's select statement was derived from information in that procedure, and lists
all jobs on a server with their name, description and schedule description.

Total article views: 4376 | Views in the last 30 days: 8
 
Related Articles
SCRIPT

get schedule description

workaround the bug in msdb..sp_get_schedule_description

SCRIPT

Agent Job Schedule Description

Yet another schedule description query with added grammatical improvements.

FORUM

Hresult: 0x80004005 Description:

Hresult: 0x80004005 Description:

FORUM

DTS Package Scheduling error

Urgent ! DTS packge Scheduling error. Step Error Description:Invalid Task Result value.

FORUM

No error description after job failure

No error description after job failure

 
Contribute