Compare and deploy sql server agent jobs
oweston12
Posts: 1 New member
in SQL Compare
Is there a way to compare and easily deploy agent jobs? I dont want to remove them if theyre different. I just want to edit it.
Tagged:
Answers
as far as I know, nothing but comparing MSDB database. But I strongly suggest to avoid that way. What about using this tool instead?
CTO @ Engage IT Services s.r.l.
Database Administrator and Team Leader
Microsoft MVP - Data Platform
Staff member of getlatestversion.it community
personal website | blog
This post was a while ago, but I am still not sure what is the best way to deploy SQL Jobs with RedGate.
In our scenario, we don't want to re-create the jobs to avoid losing schedule and history.
I would appreciate you sharing with us what approaches you have tried and which one works better for you.
Cheers,
Diego