What are the challenges you face when working across database platforms? Take the survey
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.

Comments

  • Options
    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
  • Options
    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.