sysjobschedules doen''t show correct next_run_time
-
This is little annoying that the next_run_time in sysjobschedules is not showing correct time but it is shwing correctly in Enterprise Manager.
I have a job scheduled every minute and takes less than sec to complete. Now when I was trying to generate report from sysjobschedules, the next_run_time is showing 10 minutes previous time , but the job ran successfully every minute in this time.
After waiting for 20 minutes, it is correctly showing next_run_time for the minute and then it is not refreshed next minute.
My question is how often information is upadted in sysjobschedules? How EM is showing correct next_run_time?
-
EM uses SQL-DMO which always requires refresh for everything, so the answer to your question is:
Whenever you choose the refresh context menu item on the object you want to see the latest values for.
Andy
-
You mean EM SQL DMO is also not reading data from next_run_time column in sysjobschedules?
How can I get the correct next_run_time data similar to EM? I want to generate timely report of job statuses.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply