Options

Disable/pause a scheduled backup job

jason_devjason_dev Posts: 9
edited July 6, 2012 4:41PM in SQL Backup Previous Versions
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.
· Share on Twitter

Comments

  • Options
    ChrisAVWoodChrisAVWood Posts: 361
    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
    · Share on Twitter
  • Options
    jason_devjason_dev Posts: 9
    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
    · Share on Twitter
Sign In or Register to comment.