Export (0) Print
Expand All
Expand Minimize

EnumMiscellaneousAgentViews Method

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The EnumMiscellaneousAgentViews method returns a QueryResults object that enumerates historical data for all replication agents not otherwise classified.


object
.EnumMiscellaneousAgentViews( )
as 
QueryResults

object

Expression that evaluates to an object in the Applies To list.

HRESULT EnumMiscellaneousAgentViews(
LPSQLDMOQUERYRESULTS* ppResults);

A QueryResults object that contains one result set defined by these columns.

Column Data type Description

agent_type

nvarchar(129)

Descriptive text.

job_id

binary(22)

System-assigned, unique identifier of the Microsoft SQL Server Agent job responsible for starting the agent.

local_timestamp

binary(14)

Timestamp.

message

nvarchar(1025)

Descriptive text.

name

nvarchar(129)

Name of the agent.

run_duration

integer

Cumulative run time.

start_time

nvarchar(22)

Date and time of most recent scheduled execution.

status

integer

Agent status. Interpret using SQLDMO_TASKSTATUS_TYPE.

Use the EnumMiscellaneousAgentViews method to monitor replication agent sessions.

In the result set, date, and time data returned in start_time is formatted as YYYYMMDD hh:mm:ss.fff.

Date part Description

YYYY

Represents the year in four digits.

MM

Represents the month in two digits (zero padded).

DD

Represents the day of the month in two digits (zero padded).

hh

Represents the hour using two digits, a twenty-four hour clock (zero padded).

mm

Represents the minute in two digits (zero padded).

ss

Represents the second in two digits (zero padded).

fff

Represents the fractional part of the second in three digits.

For example, the value 20040512 18:12:00.000 is interpreted as 6:12 P.M., May 12, 2004.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft