iRobot (9/18/2012)
I cannot figure out which table to get information for the next scheduled Job.Would it be dbo.sysschedules -active_start_date,active_start_time
OR
dbo.sysjobschedules- next_run_date,next_run_time?
Yes, next_run_date and next_run_time will give you what you are looking for. Be aware though that the time field is in Integer format, and won't have leading zeros, so you will have to pad the output if you are making any type of report.
Hope this helps.