Thank this author by sharing:
By Richard Sutherland, 2011/11/25
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
Hresult: 0x80004005 Description:
Urgent ! DTS packge Scheduling error. Step Error Description:Invalid Task Result value.
No error description after job failure
How to Extract Error Description in SQL Server 2000 based on Error Number
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com
