2

For many of our old servers, we have found that there are lot of SQL agent jobs which were either run as an ad-hoc for instant purpose and now no more needed OR Jobs which are not functional/working and replaced by some new jobs, are just sitting idle and occupying the unwanted attention on the job activity list:

Hence, I would like to know, should we be good to clean up all those disabled jobs? (I am not sure if they are sitting idle there, what would be current or future impact)

If yes, what should be the safest way of cleaning them in one go, for cases where there is quite a big list of disabled jobs.

4

Only you can answer if the jobs can be dropped completely. If they are not jobs like from the import/export wizard I would probably script them out. This can be done easily with PowerShell.

A quick way of dropping them is via Object Explorer details pane, it allows multiple selections and then just hit the delete key or right click and delete.

2
  • 2
    Object Explorer Details will allow you to right-click and script, too. So, you know, if you don't know PowerShell, you don't have to go learn it to save yourself a right-click. :-) Jan 28 '15 at 20:11
  • True that, just habit.
    – user507
    Jan 28 '15 at 20:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.