How can we help you today? How can we help you today?

Disable/pause a scheduled backup job

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
0

Comments

2 comments

Sort by
  • ChrisAVWood
    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
    ChrisAVWood
    0
  • jason_dev
    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
    0

Add comment

Please sign in to leave a comment.