Does anyone have a query that will use the sysJobSchedules table in MS SQL 2000 to create a result set that will give me all the expected run times of a job for a given date range?
For example if a job is scheduled to run daily between 8am - 6pm every hour i would recieve a result set as follows:
Job1 01/29/2008 08:00:00
Job1 01/29/2008 09:00:00
Job1 01/29/2008 10:00:00
Job1 01/29/2008 11:00:00
Job1 01/29/2008 12:00:00
The idea here is I'm trying to make a report that I can provide a from and to date range and return a gant chart type result to the user. I figured I would ask on here if anyones found or written a query like this before I go and write one.