Displays information on the Xactset job for an Oracle Publisher. This stored procedure is executed at the Distributor on any database.
Oracle job number.
Last date that the job ran.
Time of change
Next date that the job will run.
Flag indicating if the job is broken.
Interval for the job.
Number of failures for the job.
Name of procedure executed by the job.
Status of the job, which can be one of the following:
1 - the job is enabled.
0 - the job is disabled.
Long interval for the job.
Long threshold for the job.
Short interval for the job.
Short threshold for the job.
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.