Disable/pause a scheduled backup job

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Disable/pause a scheduled backup job

Postby jason_dev » Fri Jul 06, 2012 7:53 pm

How can I put a scheduled job (both backups and restores) on hold for a few hours?

There are times where we would like to stop the backup/restore process while we update our infrastructure and I haven't found an easy way to disable existing jobs.
jason_dev
 
Posts: 6
Joined: Mon Jul 02, 2012 10:17 pm

Postby ChrisAVWood » Fri Jul 06, 2012 8:16 pm

If these are scheduled then thw Wizard would have created SQL Agent jobs and you just need to disable them under SQL Server Agent/Jobs in SSMS.

HTH

Chris
English DBA living in CANADA
ChrisAVWood
 
Posts: 308
Joined: Tue Dec 18, 2007 6:18 pm
Location: Edmonton, Alberta, CANADA

Re:

Postby jason_dev » Fri Jul 06, 2012 9:41 pm

Chris,

That's definitely a solution. Was hoping you can disable a job via the SQL Backup GUI.

Thanks,

Jason


ChrisAVWood wrote:If these are scheduled then thw Wizard would have created SQL Agent jobs and you just need to disable them under SQL Server Agent/Jobs in SSMS.

HTH

Chris
jason_dev
 
Posts: 6
Joined: Mon Jul 02, 2012 10:17 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests