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.

Comments

  • 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
  • Chris,

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

    Thanks,

    Jason

    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
Sign In or Register to comment.