MS SQL Server - Job ran for -95444:-89:-43 hours ??

Author

Job ran for -95444:-89:-43 hours ??

Ranga

2006-10-31, 12:15 am

I have a nightly job that runs at 2.00 AM....On saturday night first it ran
for -95444:-89:-43 and again ran at 2.00 AM

I know this occured beacuse we went back one hr on saturday night at 2.00
AM....My question is why the job should run again resulting in a failed
status? SQL Server should not have run this the second time. I hope in SQL
2005 this does not happen.

Thanks,
Ranga

John Bell

2006-10-31, 7:12 pm

Hi

This would depend on when/how the next run date is calculated. This may be
how the scheduler is designed to work. If you moved the job off the hour you
should not see this occurring.

John

"Ranga" wrote:

> I have a nightly job that runs at 2.00 AM....On saturday night first it ran
> for -95444:-89:-43 and again ran at 2.00 AM
>
> I know this occured beacuse we went back one hr on saturday night at 2.00
> AM....My question is why the job should run again resulting in a failed
> status? SQL Server should not have run this the second time. I hope in SQL
> 2005 this does not happen.
>
> Thanks,
> Ranga

Sponsored Links