sys.sp_publisherproperty

Description

Displays or changes publisher properties for non-SQL Server Publishers. This stored procedure is executed at the Distributor.

Syntax

sp_publisherproperty
[ @publisher = ]
N
'publisher'
[ , [ @propertyname = ]
N
'propertyname'
]
[ , [ @propertyvalue = ]
N
'propertyvalue'
]
[ ; ]

Permissions

When changing the property for a running job, you must restart the job for the new interval to take effect. Only members of the fixed server role at the Distributor can execute. Configure the Transaction Set Job for an Oracle Publisher System stored procedures (Transact-SQL)