The job identification number for which to return information. job_id is uniqueidentifier, with a default of NULL.
[ @job_name= ] '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 cannot be specified.
[ @operation= ] 'operation'
The valid operation for the specified job. operation is varchar(64), with a default of NULL, and can be one of these values.
Server operation that requests the target server to defect from the Master SQLServerAgent service.
Job operation that removes an entire job.
Job operation that inserts an entire job or refreshes an existing job. This operation includes all job steps and schedules, if applicable.
Server operation that causes the target server to resend its enlistment information, including the polling interval and time zone to the multiserver domain. The target server also redownloads the MSXOperator details.
Server operation that sets the interval, in seconds, for target servers to poll the multiserver domain. If specified, value is interpreted as the required interval value, and can be a value from 10 to 28,800.
Job operation that requests the start of job execution.
Job operation that requests the stop of job execution.
Server operation that causes the target server to synchronize its system clock with the multiserver domain. Because this is a costly operation, perform this operation on a limited, infrequent basis.
Job operation that updates only the sysjobs information for a job, not the job steps or schedules. Is automatically called by sp_update_job.
[ @object_type= ] 'object_type'
The type of object for the specified job. object_type is varchar(64), with a default of NULL. object_type can be either JOB or SERVER. For more information about valid object_typevalues, see sp_add_category (Transact-SQL).
[ @object_name= ] 'object_name'
The name of the object. object_name is sysname, with a default of NULL. If object_type is JOB, object_nameis the job name. If object_typeis SERVER, object_nameis the server name.
[ @target_server= ] 'target_server'
The name of the target server. target_server is nvarchar(128), with a default of NULL.
[ @has_error= ] has_error
Is whether the job should acknowledge errors. has_error is tinyint, with a default of NULL, which indicates no errors should be acknowledged. 1 indicates that all errors should be acknowledged.
[ @status= ] status
The status for the job. status is tinyint, with a default value of NULL.
[ @date_posted= ] date_posted
The date and time for which all entries made on or after the specified date and time should be included in the result set. date_posted is datetime, with a default of NULL.