SQL Server Job History – Why ‘Include Step Output in History’ is Not Checked

jobssql-server-2008-r2sql-server-agent

I have a SQL Server Agent Job. The 'Include step output in history' checkbox is unchecked. However, when I right-click oon the job and select 'View History', I can see that it is tracking step output.

There is just the one step on the job.

Why is this? Am I missing some setting?

enter image description here

enter image description here

Best Answer

That check box does not prevent job step history from being recorded/stored. SQL Server is going to do all this by default and that I know of you cannot turn it off.

The check box referenced is for telling SQL Agent to store additional or more detailed job step output. It would store this information to msdb.dbo.sysjobstepslogs. Which from my testing just checking that box alone does not do anything. You would still find the table empty if you queried it. Once I also checked Log to table, ran the job again, and then it showed a record for the job step.

This would enabled on a job that runs DBCC CHECKFILEGROUP command for a database: enter image description here

Related Question