Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RoyalSher
Yak Posting Veteran
95 Posts |
 Posted - 2004-09-13 : 06:37:31
|
| Hi All I have a backup job running every night for every 1 hour between 10 pm & 6 am. 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, 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. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-13 : 07:07:41
|
| i don't know your job settings, but you can post it here for better response.have you double checked your schedule if it was not changed? Also at 5:00 am, this is not counted as 1 hour since you already ran 4:25 am which i guess you already ran the 4:00 am? |
 |
|
|
RoyalSher
Yak Posting Veteran
95 Posts |
Posted - 2004-09-14 : 06:44:05
|
| jenI haven't replied early as I was waiting for today morning. I checked the job run status around 4.40 am ET, and found to my surprise the job would run again at 6 am and won't run at 5 am !!!?I have changed the job schedule to run between 11 pm - 6 am from 10 pm - 6 am..how can this affect the changes..And here is the setting (script)-- Add the job schedules EXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID, @name = N'Nightly Schedule', @enabled = 1, @freq_type = 4, @active_start_date = 20040121, @active_start_time = 230000, @freq_interval = 1, @freq_subday_type = 8, @freq_subday_interval = 1, @freq_relative_interval = 0, @freq_recurrence_factor = 0, @active_end_date = 99991231, @active_end_time = 45959 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback EXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID, @name = N'Daily Schedule', @enabled = 1, @freq_type = 4, @active_start_date = 20040407, @active_start_time = 60000, @freq_interval = 1, @freq_subday_type = 4, @freq_subday_interval = 10, @freq_relative_interval = 0, @freq_recurrence_factor = 0, @active_end_date = 99991231, @active_end_time = 210000 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback Anybody else in the group have any other thoughts ?ThanksRoyalSher.*********The world is the great gymnasium where we come to make ourselves strong. |
|
|
|
|
|
|
|
|
Job schedule