My job history appears to be large, how do I clear it? Can I limit it's growth?
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Clearing: SQL Server Agent > Jobs > Select the Job > Right mouse click (View History) > Highlight one or more log file summary from the list > Delete
Limiting the growth: SQL Server Agent > Properties > History > Automatically remove agent history older than …
You can also call the stored procedure sp_purge_jobhistory
No one has followed this question yet.
In net all the scripts are for VBS Script ie name.vbs
can't find the object that is running this SQL job
How do I log all details from a job step to a file?
One job runs many jobs in parallel
SQL Agent & SSIS job step