Red Gate forums :: View topic - Disable/pause a scheduled backup job
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Disable/pause a scheduled backup job

 Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
jason_dev



Joined: 02 Jul 2012
Posts: 6
PostPosted: Fri Jul 06, 2012 7:53 pm    Post subject: Disable/pause a scheduled backup job Reply with quote
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.
Back to top
View user's profile Send private message
ChrisAVWood



Joined: 18 Dec 2007
Posts: 308
Location: Edmonton, Alberta, CANADA
PostPosted: Fri Jul 06, 2012 8:16 pm    Post subject: Reply with quote
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
Back to top
View user's profile Send private message
jason_dev



Joined: 02 Jul 2012
Posts: 6
PostPosted: Fri Jul 06, 2012 9:41 pm    Post subject: Re: Reply with quote
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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group