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