overlapping job

Hi,
If a job is scheduled to run every minute, what happens if
the job takes longer than 1 minute to execute.
Will a second occurence of the job run or will it wait for
the first occurence of the job to finish or will it not
run.
Thanks,
ned
To take an example, if the job takes 1 min 10 seconds to run and is
scheduled to run every minute it will in fact run every 2 minutes.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ned Radenovic" <anonymous@.discussions.microsoft.com> wrote in message
news:00c901c492b7$ea326c20$a401280a@.phx.gbl...
> Hi,
>
> If a job is scheduled to run every minute, what happens if
> the job takes longer than 1 minute to execute.
> Will a second occurence of the job run or will it wait for
> the first occurence of the job to finish or will it not
> run.
> Thanks,
> ned
|||Thanks,
Ned
>--Original Message--
>To take an example, if the job takes 1 min 10 seconds to
run and is
>scheduled to run every minute it will in fact run every 2
minutes.
>--
>HTH
>Jasper Smith (SQL Server MVP)
>http://www.sqldbatips.com
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>"Ned Radenovic" <anonymous@.discussions.microsoft.com>
wrote in message[vbcol=seagreen]
>news:00c901c492b7$ea326c20$a401280a@.phx.gbl...
if[vbcol=seagreen]
for
>
>.
>