Skip to content

Latest commit

 

History

History
132 lines (93 loc) · 4.34 KB

sp-help-jobsteplog-transact-sql.md

File metadata and controls

132 lines (93 loc) · 4.34 KB
Raw
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs monikerRange
sp_help_jobsteplog (Transact-SQL)
Returns metadata about a specific SQL Server Agent job step log.
markingmyname
maghan
randolphwest
05/14/2024
sql
system-objects
reference
sp_help_jobsteplog_TSQL
sp_help_jobsteplog
sp_help_jobsteplog
TSQL
>=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current

sp_help_jobsteplog (Transact-SQL)

[!INCLUDE SQL Server]

Returns metadata about a specific [!INCLUDE ssNoVersion] Agent job step log. sp_help_jobsteplog doesn't return the actual log.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

sp_help_jobsteplog
    [ [ @job_id = ] 'job_id' ]
    [ , [ @job_name = ] N'job_name' ]
    [ , [ @step_id = ] step_id ]
    [ , [ @step_name = ] N'step_name' ]
[ ; ]

Arguments

[ @job_id = ] 'job_id'

The job identification number for which to return job step log information. @job_id is uniqueidentifier, with a default of NULL.

Either @job_id or @job_name must be specified, but both can't be specified.

[ @job_name = ] N'job_name'

The name of the job. @job_name is sysname, with a default of NULL.

Either @job_id or @job_name must be specified, but both can't be specified.

[ @step_id = ] step_id

The identification number of the step in the job. If not included, all steps in the job are included. @step_id is int, with a default of NULL.

[ @step_name = ] N'step_name'

The name of the step in the job. @step_name is sysname, with a default of NULL.

Return code values

0 (success) or 1 (failure).

Result set

Column name Data type Description
job_id uniqueidentifier Unique identifier of the job.
job_name sysname Name of the job.
step_id int Identifier for the step within the job. For example, if the step is the first step in the job, its step_id is 1.
step_name sysname Name of the step in the job.
step_uid uniqueidentifier Unique identifier of the step (system generated) in the job.
date_created datetime Date that the step was created.
date_modified datetime Date that the step was last modified.
log_size float Size of the job step log, in megabytes (MB).
log nvarchar(max) Job step log output.

Remarks

sp_help_jobsteplog is in the msdb database.

Permissions

[!INCLUDE msdb-execute-permissions]

Other users must be granted one of the following [!INCLUDE ssNoVersion] Agent fixed database roles in the msdb database:

  • SQLAgentUserRole
  • SQLAgentReaderRole
  • SQLAgentOperatorRole

For details about the permissions of these roles, see SQL Server Agent Fixed Database Roles.

Members of SQLAgentUserRole can only view job step log metadata for job steps that they own.

Examples

A. Returns job step log information for all steps in a specific job

The following example returns all the job step log information, for the job named Weekly Sales Data Backup.

USE msdb;
GO

EXEC dbo.sp_help_jobsteplog
    @job_name = N'Weekly Sales Data Backup';
GO

B. Return job step log information about a specific job step

The following example returns job step log information, about the first job step for the job named Weekly Sales Data Backup.

USE msdb;
GO

EXEC dbo.sp_help_jobsteplog
    @job_name = N'Weekly Sales Data Backup',
    @step_id = 1;
GO

Related content