sp_helpxactsetjob (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Displays information on the Xactset job for an Oracle Publisher. This stored procedure is executed at the Distributor on any database.

Topic link icon Transact-SQL Syntax Conventions


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.

Result Sets

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.

See Also

Configure the Transaction Set Job for an Oracle Publisher (Replication Transact-SQL Programming)
sp_publisherproperty (Transact-SQL)