the same time and repeat every 15 minutes. This has worked correctly
until last w

were produced and Agent said the jobs completed successfully, no reason
given as to why they failed to repeat.
Does anyone have any suggestions?
Thanks,
CurtIn order to try helping you I would need to know more details about what has
lead to the change in system's behavior. Did you add new jobs, did the
system go under heavy load, have you changed schedules manually etc. ?
It would also help if you look at agent's error log for some clues.
Ciprian Gerea
SDE, SqlServer
This posting is provided "AS IS" with no warranties, and confers no rights.
<curtmorrison@.yahoo.com> wrote in message
news:1145901222.247025.29230@.t31g2000cwb.googlegroups.com...
>I have several log shipping restore jobs that are scheduled to start at
> the same time and repeat every 15 minutes. This has worked correctly
> until last w

> were produced and Agent said the jobs completed successfully, no reason
> given as to why they failed to repeat.
> Does anyone have any suggestions?
> Thanks,
> Curt
>|||Is it possible that if the job is set the repeat every 15 minutes, but
the inital job takes over 2 hours to complete, the agent scheduler will
give up on it? The jobs that are repeating correctly only take about 10
minutes at most to complete, while all the jobs that are failing to
repeat are averaging about 1.5 hours.|||The scheduler does not give up on the job, but the job won't be executed if
it's already running. After the 2 hour time period elapses, does the
recurring job get rescheduled?
Ciprian Gerea
SDE, SqlServer
This posting is provided "AS IS" with no warranties, and confers no rights.
<curtmorrison@.yahoo.com> wrote in message
news:1145995810.372988.102280@.e56g2000cwe.googlegroups.com...
> Is it possible that if the job is set the repeat every 15 minutes, but
> the inital job takes over 2 hours to complete, the agent scheduler will
> give up on it? The jobs that are repeating correctly only take about 10
> minutes at most to complete, while all the jobs that are failing to
> repeat are averaging about 1.5 hours.
>|||After the 2 hour time period elapses, the recurring job doesn't run
again until the following day as scheduled.
No comments:
Post a Comment