July 27, 2011 at 4:39 am
Hi,
Can anyone give some idea how the Sql Server Agent is calculating the next_run_date of the scheduled job.
Whether it will use any stored procedure to calculate this..?
please advise me.
--Thanks
Santosh.
July 29, 2011 at 11:33 am
santoooo (7/27/2011)
Can anyone give some idea how the Sql Server Agent is calculating the next_run_date of the scheduled job.Whether it will use any stored procedure to calculate this..?
That's proprietary code and we can only guess. Most likely they do the same way we would do it, datetime math... take the last execution datetime and add the interval.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 29, 2011 at 11:35 am
What do you want to do with this? Maybe we can help out if you can give more details.
August 1, 2011 at 12:48 am
HI
Thanks for your repsonse.
We have a requirement which is very similar to SQL Server Agent Scheduler,
User will schedule the reports in our application, so i have taken the prototye of the SQL ServerAgent Scheduler and trying to calculate the NextRunDate of each scheduledreport,
we have an windows service that pulls all the scheduled reports based on the NextRunDate and email the reports.
For this i m looking for Calcuation of NextRunDate.
Thanks
Santosh.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply