SQLServer.RemoteServer Object
Returns information about a scheduled synchronization task for a publication and database on a remote server. The synchronization task information is returned in a QueryResults object.
QueryResults = RemoteServer.EnumPublicationSyncTask (
[DatabaseName :=] idPubDatabase,
[PublicationName :=] idPublication )
HRESULT pRemoteServer->EnumPublicationSyncTask (
SQLOLE_LPCSTR idPubDatabase,
SQLOLE_LPCSTR idPublication,
LPSQLOLEQUERYRESULTS* ppQueryResults );
| Element | Type | Description |
|---|
| QueryResults | QueryResults | Returned QueryResults object |
| idPubDatabase | Identifier | Database on the remote server that contains the publication |
| idPublication | Identifier | Publication |
| ColumnName | ColumnType |
|---|
| name | SQLOLE_DTypeChar |
| id | SQLOLE_DTypeInt4 |
| subsystem | SQLOLE_DTypeChar |
| server | SQLOLE_DTypeChar |
| username | SQLOLE_DTypeChar |
| ownerloginname | SQLOLE_DTypeChar |
| databasename | SQLOLE_DTypeChar |
| enabled | SQLOLE_DTypeInt1 |
| freqtype | SQLOLE_DTypeInt4 |
| freqinterval | SQLOLE_DTypeInt4 |
| freqsubtype | SQLOLE_DTypeInt4 |
| freqsubinterval | SQLOLE_DTypeInt4 |
| freqrelativeinterval | SQLOLE_DTypeInt4 |
| freqrecurrencefactor | SQLOLE_DTypeInt4 |
| activestartdate | SQLOLE_DTypeInt4 |
| activeenddate | SQLOLE_DTypeInt4 |
| activestarttimeofday | SQLOLE_DTypeInt4 |
| activeendtimeofday | SQLOLE_DTypeInt4 |
| lastrundate | SQLOLE_DTypeInt4 |
| lastruntime | SQLOLE_DTypeInt4 |
| nextrundate | SQLOLE_DTypeInt4 |
| nextruntime | SQLOLE_DTypeInt4 |
| runpriority | SQLOLE_DTypeInt4 |
| emailoperatorname | SQLOLE_DTypeChar |
| retryattempts | SQLOLE_DTypeInt4 |
| retrydelay | SQLOLE_DTypeInt4 |
| datecreated | SQLOLE_DTypeDateTime |
| datemodified | SQLOLE_DTypeDateTime |
| command | SQLOLE_DTypeChar |
| lastruncompletionlevel | SQLOLE_DTypeInt4 |
| lastrunduration | SQLOLE_DTypeInt4 |
| lastrunretries | SQLOLE_DTypeInt4 |
| loghistcompletionlevel | SQLOLE_DTypeInt4 |
| emailcompletionlevel | SQLOLE_DTypeInt4 |
| description | SQLOLE_DTypeChar |
| tagadditionalinfo | SQLOLE_DTypeChar |
| tagobjectid | SQLOLE_DTypeInt4 |
| tagobjecttype | SQLOLE_DTypeInt4 |
sp_helppublicationsync