| title | sp_helpxactsetjob (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql-server-2016 | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| applies_to |
|
||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 242cea3e-e6ac-4f84-a072-b003b920eb33 | ||
| caps.latest.revision | 19 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Displays information on the Xactset job for an Oracle Publisher. This stored procedure is executed at the Distributor on any database.
Transact-SQL Syntax Conventions
sp_helpxactsetjob [ @publisher = ] 'publisher'
[@publisher = ] 'publisher'
Is the name of the non-[!INCLUDEssNoVersion] 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. |
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)