Displays information on the Xactset job for an Oracle Publisher. This stored procedure is executed at the Distributor on any database.
sp_helpxactsetjob [ @publisher = ] 'publisher'
[@publisher = ] 'publisher'
Is the name of the non- SQL Server Publisher to which the job belongs. publisher is sysname, with no default.
|Column name||Data type||Description|
|jobnumber||int||Oracle job number.|
|lastdate||varchar(22)||Last date that the job ran.|
|thisdate||varchar(22)||Time of change|
|nextdate||varchar(22)||Next date that the job will run.|
|broken||varchar(1)||Flag indicating if the job is broken.|
|interval||varchar(200)||Interval for the job.|
|failures||int||Number of failures for the job.|
|xactsetjobwhat||varchar(200)||Name of procedure executed by the job.|
|xactsetjob||varchar(1)||Status of the job, which can be one of the following:
1 - the job is enabled.
0 - the job is disabled.
|xactsetlonginterval||int||Long interval for the job.|
|xactsetlongthreshold||int||Long threshold for the job.|
|xactsetshortinterval||int||Short interval for the job.|
|xactsetshortthreshold||int||Short threshold for the job.|
Return Code Values
0 (success) or 1 (failure)
sp_helpxactsetjob is used in snapshot replication and transactional replication for an Oracle Publishers.
sp_helpxactsetjob always returns the current settings for the Xactset job (HREPL_XactSetJob) at the publisher. If the Xactset job is currently in the job queue, it additionally returns attributes of the job from the USER_JOB data dictionary view created under the administrator account at the Oracle Publisher.
Only a member of the sysadmin fixed server role can execute sp_helpxactsetjob.