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.
Aucun commentaire:
Enregistrer un commentaire