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)
Thank this author by sharing:
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.
workaround the bug in msdb..sp_get_schedule_description
Yet another schedule description query with added grammatical improvements.
Hresult: 0x80004005 Description:
Urgent ! DTS packge Scheduling error. Step Error Description:Invalid Task Result value.
No error description after job failure