If I stop SQL Server Manager and then restart it will the jobs that
should have ran during the time period automatically start or do I have
to start them manually?

Thanks

Barry

No, if SQL Server Agent misses an event (either due to not being enabled or
due to the previous instance overunning the buffer period), it will wait
until the next time around.

This is one reason it is dangerous to write queries that assume they will
run at an exact time, e.g. 11:59:59 to roll up today's data...

A





Show quoteHide quote

Thanks Aaron - I thought that was the case.

Barry

Parameterize table name without constructing dynamic query?
use trigger
Is subquery bad?
Max date in a row
Left trimming little squares/spaces