SQLServer.RemoteServer Object
Lists tasks on a remote server. List is returned in a QueryResults object.
QueryResults = RemoteServer.EnumTasks (
[[TaskName :=] idTaskName,]
[[TaskID :=] nTaskID] )
HRESULT pRemoteServer->EnumTasks (
LPSQLOLEQUERYRESULTS* ppQueryResults,
SQLOLE_LPCSTR idTaskName = NULL,
long nTaskID = 0 );
| Element | Type | Description |
|---|
| QueryResults | QueryResults | Returned QueryResults object |
| idTaskName | Identifier | Name of the task |
| nTaskID | Long | Task ID |
| 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_helptask