sp_help_jobserver
Returns information about the server for a given job.
Syntax
sp_help_jobserver [ @job_id = ] job_id |
[ @job_name = ] 'job_name'
[ , [ @show_last_run_details = ] show_last_run_details ]
Arguments
[@job_id =] job_id
Is the job identification number for which to return information. job_id is uniqueidentifier, with a default of NULL.
[@show_last_run_detail =] 'job_name'
Is the job name for which to return information. job_name is sysname, with a default of NULL.
Note Either job_id or job_name must be specified, but both cannot be specified.
[@show_last_run_details =] show_last_run_details
Is whether the last-run execution information is part of the result set. show_last_run_details is tinyint, with a default of 0. 0 does not include last-run information, and 1 does.
Return Code Values
0 (success) or 1 (failure)
Result Sets
| Column name | Data type | Description |
|---|---|---|
| server_id | int | Identification number of the target server. |
| server_name | nvarchar(30) | Computer name of the target server. |
| enlist_date | datetime | Date the target server enlisted into the master server (MSX). |
| last_poll_date | datetime | Date the target server last polled the MSX. |
If sp_help_jobserver is executed with show_last_run_details set to 1, the result set has these additional columns.
| Column name | Data type | Description |
|---|---|---|
| last_run_date | Int | Date the job last started execution on this target server. |
| last_run_time | Int | Time the job last started execution on this server. |
| last_run_duration | Int | Duration of the job the last time it ran on this target server (in seconds). |
| last_outcome_message | nvarchar(1024) | Outcome of the job the last time it ran on this server:
0 = Failed |
Permissions
Permissions to execute this procedure default to the sysadmin fixed server role or the db_owner fixed data base role, who can grant permissions to other users.
Examples
This example returns information, including last-run information, about the Archive Tables job.
USE msdb
EXEC sp_help_jobserver @job_name = 'Archive Tables',
@show_last_run_details = 1