sp_helpxactsetjob (Transact-SQL)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

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.