Hi,
Please let me know how to generate script for all SQL Server Agent jobs and recreate them on another instance.
Thanks, Kiran
asked
generate script for all jobs of sql server and recreate them on another instance
You can use a tool such as Redgate SQL Compare and Redgate SQL Data compare.
You can script each job one by one - right click the job, script job as, create to, new query editor window.
Or, you can backup and restore your msdb to the other database server.
You can also use an SSIS job to transfer the sysjobs tables. You should probably also transfer the backup* tables as well as sysdts - in case you have ssis or dts packages saved in msdb.
If you are setting up mirrorng, you should not need to script the database to get the copy the database. As per the instructions on setting up mirring, these might come in handy, you simply have to do a restore of a recent full backup.
Thanks for replying. I do not want to script the database. I want to script out all the agent jobs on one instance and cpoy them to another instance. This is the requirement.
