Job schedules in sql server 2005 are stored in a very difficult to read format. The sql server agent allows for many types of recurring and non recurring schedules. I wrote this query to break down the msdb.dbo.sysschedules table into a format that we can easily read and understand. I based the description column off of the info provided in the new schedule creation GUI window.
Simply run this from any SQL Server (only tested in 2005) and it will break down your job schedules into a readable format.
Enjoy
-Michael Abair
