79265201

Date: 2024-12-09 13:56:12
Score: 0.5
Natty:
Report link

In SSMS you can select multiple Jobs to be "extracted" into a single script:

  1. In "Object Explorer" select "Jobs":

Jobs folder selected in Object Explorer

  1. Press "F7" to open "Object Explorer Details" (you can also open it via View->Object Explorer Details):

Job list in Object Explorer Details

  1. Select all of the Jobs you want to export and right click to bring up a pop up menu. Select "Script Job As" and so on.

enter image description here

P.S. This trick works for many things

Reasons:
  • Probably link only (1):
  • No code block (0.5):
  • High reputation (-1):
Posted by: Alex