June 22, 2009 at 3:51 pm
Hi
Can someone please help to get the script to list all the SQL jobs scheduled to run for a particular Date?
Thanks in Advance
Shuaib
June 22, 2009 at 4:40 pm
select j.name, s.next_run_date, s.next_run_time
from dbo.sysjobschedules s join dbo.sysjobs j
on s.job_id = j.job_id
where s.next_run_date = 20090623
Greg
June 22, 2009 at 4:59 pm
Thanks Greg, this script will return immediate next run time of a job, but I am looking for a script which would retrun all the scheduled jobs for a particular given date (future date).
Ex: I want to know what are all jobs are going to run on 06/25/2009?
Thanks
Shuaib
June 23, 2009 at 8:20 am
Did you try running it? It will return all the jobs that are scheduled to run on 06/23/2009. Change the date to the 25th and run it in msdb (I forgot to include 'use msdb' in the script).
Greg
June 13, 2012 at 8:32 am
Hello Shuaib-641712 -
did you ever figure out how to do this? I am looking for the same tool.
Thanks!
Kevin
June 14, 2012 at 9:43 am
Thanks, Greg, that was something I was looking for too!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply