copying sql server jobs

In SSMS you can select a SQL Agent job, right click and script it as a CREATE. That will give you a script that you can run on another server to create the same job.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.