Disable a regular backup job

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

ChiragNS One Orange Chip Points: 26137 More actions · Answer 1

hi

A job can have multiple schedules. Disabling a job disables all the schedules in a job. Disabling a schedule disables only that schedule in a job.

If your job has only one schedule then disabling the job or the schedule should be the same but iam not very sure.

Anyway what do u mean by "I want to disable my regular backup job regularly."

"Keep Trying"

Susan S SSCommitted Points: 1771 More actions · Answer 2

I guess I will use ' disable job' because this job there are multiple schedule.

regular backup job... back DB and log

thanks,

Susan

MohammedU SSCoach Points: 19644 More actions · Answer 3

Just curious...what is the reason for disabling the backup job which is one of the important one...

You can use msdb..sp_update_job procedure too in QA...

To diable:

exec msdb..sp_update_job @job_name = 'Job Name' , @enabled = 0

To Eanble:

exec msdb..sp_update_job @job_name = 'Job Name' , @enabled = 1

MohammedU
Microsoft SQL Server MVP

Susan S SSCommitted Points: 1771 More actions · Answer 4

Thanks guy.

I need to disable temporary because we need to upgrade one of the DB and can't be disturbed by any backup.