sp_helpxactsetjob (Transact-SQL)


Applies To: SQL Server

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.

Column nameData typeDescription
jobnumberintOracle job number.
lastdatevarchar(22)Last date that the job ran.
thisdatevarchar(22)Time of change
nextdatevarchar(22)Next date that the job will run.
brokenvarchar(1)Flag indicating if the job is broken.
intervalvarchar(200)Interval for the job.
failuresintNumber of failures for the job.
xactsetjobwhatvarchar(200)Name of procedure executed by the job.
xactsetjobvarchar(1)Status of the job, which can be one of the following:

 1 - the job is enabled.

 0 - the job is disabled.
xactsetlongintervalintLong interval for the job.
xactsetlongthresholdintLong threshold for the job.
xactsetshortintervalintShort interval for the job.
xactsetshortthresholdintShort threshold for the job.

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.

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

Community Additions