Find future date of the Jobs

  • :-)Hi All,

    Can anyone help me out this regarding?

    I have two parameters named @report_start_time and @report_end_time

    I need to write the procedure with the above parameters to fetch the list of all the jobs that will run on the given future date intervals.

    Please find the structure of the table below.

    Job_Id, Job_Name, Start_Date, End_Date, Frequency

    1 JOB1 Oct-20-2010 Oct-20-3000 2 Months once

    2 JOB2 Sep-10-2010 Sep-10-3000 2 Weeks once

    Sample Imput

    @report_start_time = '12/01/2010'

    @report_end_time = '12/01/2013'

    Kindly do the needful.

    Thanks & Regards,

    Krishna:-)

  • You may find this script[/url] on SSC useful.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

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

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