How to export all job in SQL Server

Application Scenario:

You will need to export these jobs as SQL scripts during the migration of all job (job) from the source SQL Server database server to the destination database server.

Operation Steps:

1. In Microsoft SQL Server Management Studio, select SQL Server agent->jobs, press F7 to open the Object Explorer Details window, and select all jobs;

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/SQLServer/

2, click the right mouse button, select the script Job as->create to->new query Editor Windows, and then all jobs will be SQL script to display in the query window.