scheduled jobs question

what are the elements that I should review to ensure multiple scheduled SQL
jobs do not ''collide'' with each other? Thank you.
You can have only one instance of a scheduled job running at a given time.
However, you could have several different jobs that could conflict. Check
out sp_getapplock and sp_releaseapplock in the BOL for a means of dealing
with this issue.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"baybreeze" <baybreeze@.discussions.microsoft.com> wrote in message
news:1FBF3609-8879-4E84-AEC0-050EED1A3154@.microsoft.com...
what are the elements that I should review to ensure multiple scheduled SQL
jobs do not ''collide'' with each other? Thank you.
|||What is yoru specifc issue?
What you can also do is start others jobs based on conditions is other
jobs using sp_start_job. Sometimes I will use this technique to start
a fullbackup job after DBCC runs.
Bert

scheduled jobs question

what are the elements that I should review to ensure multiple scheduled SQL
jobs do not ''collide'' with each other? Thank you.You can have only one instance of a scheduled job running at a given time.
However, you could have several different jobs that could conflict. Check
out sp_getapplock and sp_releaseapplock in the BOL for a means of dealing
with this issue.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"baybreeze" <baybreeze@.discussions.microsoft.com> wrote in message
news:1FBF3609-8879-4E84-AEC0-050EED1A3154@.microsoft.com...
what are the elements that I should review to ensure multiple scheduled SQL
jobs do not ''collide'' with each other? Thank you.|||What is yoru specifc issue?
What you can also do is start others jobs based on conditions is other
jobs using sp_start_job. Sometimes I will use this technique to start
a fullbackup job after DBCC runs.
Bertsql