EnumTasks List

SQLServer.RemoteServer Object

Description

Lists tasks on a remote server. List is returned in a QueryResults object.

Visual Basic

QueryResults = RemoteServer.EnumTasks (
[[TaskName :=] idTaskName,]
[[TaskID :=] nTaskID] )

C++

HRESULT pRemoteServer->EnumTasks (
LPSQLOLEQUERYRESULTS*
ppQueryResults,
SQLOLE_LPCSTR idTaskName = NULL,
long
nTaskID = 0 );

Elements

Element Type Description

QueryResults QueryResults Returned QueryResults object
idTaskName Identifier Name of the task
nTaskID Long Task ID

QueryResults

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

Reference

sp_helptask