SQL Server Performance Forum – Threads Archive

Job schedule

Hi All I have a backup job running every night for every 1 hour between 10 pm & 6 am ET. I had to make some changes to backup script and change of schedule, from 10 pm – 6 am to 11 pm – 6 am. After the changes to schedule I have run the job at 4:25 am ET, to check if the script was doing fine after implementing the final changes. The script did good in its job by backing up the database, but to my surprise, I happen to check if the next schedule would be at 5 am. It was showing 6 am and not 5 am which is the next hour of schedule. Any thoughts on this ? Thanks in advance. RoyalSher.
*********
The world is the great gymnasium where we come to make ourselves strong.

I believe you got these values from Enterprise Manager, may I ask to execute SP_HELP_JOB from query analyzer for the job and see the next execution date. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Satya, Yes, I did check the job using Sp_help_job and moreover the job has run for the day at 6 am et, so the next execution date and time would be for next schedule, which may not be of much help!? The job hasn’t run at 5 am schedule as part of the history I check, and yes this observations were thro’ EM. Any thoughts ? Thanks RoyalSher.
*********
The world is the great gymnasium where we come to make ourselves strong.

I had to make some changes to backup script and change of schedule, from 10 pm – 6 am to 11 pm – 6 am… no value about to run at 05:00 am for this job. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>