How to: Delete a Job Step Log (Transact-SQL)

This topic describes how to use stored procedures to delete a SQL Server Agent job step log. For more information, see "Job Step Logs" in Creating Job Steps.

To delete a SQL Server Agent job step log

  • Execute sp_delete_jobsteplog using the name of the job that contains the job step log to be deleted. You can also specify the step ID or name, the size of the job step logs to be deleted, or the age of the job step logs to be deleted.