dbo.sysjobstepslogs (Transact-SQL)

Contains the job step log for all SQL Server Agent job steps that are configured to write job step output to a table. This table is stored in the msdb database.

Column name

Data type

Description

log_id

int

ID of the job step log.

log

nvarchar(max)

Job step log contents.

date_created

datetime

Date and time that the job step log was created.

date_modified

datetime

Date and time that the job step log was last modified.

log_size

int

Size of the job step log in bytes.

step_uid

uniqueidentifier

Unique identifier of the job step.

See Also

Reference

sp_help_jobsteplog (Transact-SQL)

sp_delete_jobsteplog (Transact-SQL)