2020年11月1日 星期日

Export SQL Server Agent Jobs

You can do all your Agent jobs in one go fairly easy:

1. Click on the "Jobs" section in the SQL Agent in SSMS

2. Hit the F7 key on your keyboard (opens the Object Explorer Details)

3. Highlight the jobs you want to export in the Object Explorer Details

4. Right-click the highlighted jobs and "Script Job As..." like you would for a single job

沒有留言:

張貼留言

Ads

Seo Services