I recently saw some kind of export of SQL jobs configured under SQL Server Agent that I would like to achieve as well. Unfortunately I don't have any trace to author of that report to ask him\her about report creation, hence looking for help here as I had no luck googling it nor searching in here.
Report was in excel (so I guess originally was some csv or maybe directly xls) and contained every single job from SQL instance with one step per row and most importantly containing also script content of each job step and some further details.
As for an example as SQL has default job syspolicy_purge_history only, export will contain 3 rows for each of it's step.
I can't seem to find it as any build in export, so I guess some query maybe or I have missed this somewhere
Anyone aware of any such report? Any help is welcome
Aucun commentaire:
Enregistrer un commentaire