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
沒有留言:
張貼留言