Post reply

Query to predict future job schedules from MSDB tables

  • May 8, 2014 at 11:54 am

    #288550

    I want to query my msdb job and jobschedule related tables to generate a list of runtimes for each of these jobs for the next day or any future date. This query should output JobID, Run_Date(YYYYMMDD), and Run_Time(HHMMSS).

    If I have 3 jobs with...

    Job#1 scheduled to run once every 4 hours between 6 AM and 10 PM

    Job# 2 scheduled to run every 15 minutes between 11 AM and 1 PM

    Job# 3 scheduled to run every minute between 4 PM and 4:15 PM

    my output should look as below

    Thanks in advance for your inputs

  • May 9, 2014 at 7:16 am

    #1712152

    may i know where you need help in your query?

    Every rule in a world of bits and bytes, can be bend or eventually be broken
    MyBlog About Common dialog control
    A Visualizer for viewing SqlCommand object script [/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply