sp_helpxactsetjob (Transact-SQL)

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

Topic link iconTransact-SQL Syntax Conventions

Syntax

sp_helpxactsetjob [ @publisher = ] 'publisher' 

Arguments

  • [@publisher = ] 'publisher'
    Is the name of the non-SQL Server Publisher to which the job belongs. publisher is sysname, with no default.

Return Code Values

0 (success) or 1 (failure)

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.

Remarks

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.

Permissions

Only a member of the sysadmin fixed server role can execute sp_helpxactsetjob.

See Also

Reference

sp_publisherproperty (Transact-SQL)

Other Resources

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

Help and Information

Getting SQL Server 2005 Assistance