:-)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:-)