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.

Improve this question

1 Answer 1

Reset to default
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.

Improve this answer
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. :-)
    – Aaron Bertrand
    Commented Jan 28, 2015 at 20:11
  • True that, just habit.
    – user507
    Commented Jan 28, 2015 at 20:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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