I need to know what behaviour SQL Server Agent has with a scheduled DTS
package that takes longer to run than the next schedule period. for example
say a package is scheduled to run everyday at 11:00, but the packages takes
27 hours to finish.

What is the default action of the server agent.

Does it
a: run the schedule at ever schedule, therefore multiple instanses of the
package will be running.
b: wait till the current run is complete and then start the job again.
c: not run the job again and never run the job again as the scheduled start
time has been past.

Pete

It won't run two of the same jobs concurrently. It will wait
until the next 11:00 period when it isn't running and run it
at that time.

-Sue

On Mon, 24 Oct 2005 08:56:01 -0700, Peter Watson <Peter
Watson (AT) discussions (DOT) microsoft.com> wrote: