Unable to get a list of SQL scheduled jobs for a future date
Currently in SQL 2005(and in 2000), if you've got daily/weekly/monthly sql jobs setup, you cannot get a snapshot of the jobs(that will run) for a future data and time(range).
To a certain extent, you can get some info by reading system tables(in msdb) such as sysjobs and sysjobshedules - but, this is very convoluted as you have to traverse various options and flags!
Upvotes: 0<=-=Sep 28 2006 8:20AM=-=>
You reported that SQL Server provides insufficient reporting about jobs to be run in the future. Your request is sensible, and we will consider it for inclusion in our next release. In the meantime, check out custom reports in our next service pack. You should be able to create a panel that has the information you seek. (Though this would require working through the existing msdb system tables.)
jkh<=-=Oct 28 2008 12:30PM=-=>
We are considering this for SQL11