How to set up a threshold on a SQL Server 2000 Agent backup job?

Tags:
Microsoft SQL Server 2000
SQL Server Agent
SQL Server backup
I would like advice on setting up a threshold if a SQL Server 2000 Agent backup job (nightly) is running after a certain time (7 a.m. PST), I would like to cancel it.

Answer Wiki

Thanks. We'll let you know when a new response is added.

The way to do this is to setup a second job which runs at 7am, and looks to see if the job is still running. If the job is still running then use the sp_stop_job to stop the backup job.

It’s best to let backup jobs complete as if you don’t then you don’t have a good backup in case something goes wrong.

Does your backup often take until 7am? If it does you may need to look at where you are backing up to as it may not be fast enough.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following