Post reply

Script for SQL Job Schedule Details

  • June 22, 2009 at 3:51 pm

    #205776

    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

    #1013639

    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

    #1013641

    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

    #1013972

    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

    #1500407

    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

    #1501132

    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