SQLTeam.com | Weblogs | Forums

Specify a job not to copy when using Transfer Jobs Task


#1

I am setting up a new package and want to use the Transfer Jobs Task Editor for our Availability groups. My question is is there a way to "TransferAllJobs" but exclude one specific one?


#2

Maybe copy all jobs and then do a msdb.dbo.sp_delete_job to remove that one job?