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.
sql server job error Sql Severity -16,Sql Message ID -536
The job "ASPState_Job_DeleteExpiredSessions" filling up SQL Agent job history
generate script for all jobs of sql server and recreate them on another instance
RE:connection errors while running automated job
SQL Agent CmdExec proxy ignored