Freigeben über


Microsoft.SqlServer.Management.Smo.Agent Namespace

Classes

AgentObjectBase
Alert

Instance class encapsulating : Server[@Name='']/JobServer/Alert

AlertCategory

Instance class encapsulating : Server[@Name='']/JobServer/AlertCategory

AlertCategoryCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

AlertCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

AlertSystem

Instance class encapsulating : Server[@Name='']/JobServer/AlertSystem

CategoryBase
Job

Instance class encapsulating : Server[@Name='']/JobServer/Job

JobCategory

Instance class encapsulating : Server[@Name='']/JobServer/JobCategory

JobCategoryCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

JobCollection
JobFilter

The JobFilter object is used to constrain the output of the EnumJobs method of the JobServer object.

JobHistoryFilter

Settings to control enumeration of agent job history for various JobServer methods

JobSchedule

Instance class encapsulating : Server[@Name='']/JobServer/Job/Schedule

JobScheduleCollection

Strongly typed collection of MAPPED_TYPE objects Supports indexing objects by their Name and Schema properties

JobServer

Instance class encapsulating : Server[@Name='']/JobServer

JobStep

Instance class encapsulating : Server[@Name='']/JobServer/Job/Step

JobStepCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

Operator

Instance class encapsulating : Server[@Name='']/JobServer/Operator

OperatorCategory

Instance class encapsulating : Server[@Name='']/JobServer/OperatorCategory

OperatorCategoryCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

OperatorCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

ProxyAccount

Instance class encapsulating : Server[@Name='']/JobServer/ProxyAccount

ProxyAccountCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

ScheduleBase
TargetServer

Instance class encapsulating : Server[@Name='']/JobServer/TargetServer

TargetServerCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

TargetServerGroup

Instance class encapsulating : Server[@Name='']/JobServer/TargetServerGroup

TargetServerGroupCollection

Strongly typed list of MAPPED_TYPE objects Has strongly typed support for all of the methods of the sorted list class

Enums

ActivationOrder
AgentLogLevels

specifies the level of information that is logged in the SQL Server Agent error log.

AgentMailType

Specifies mail subsystems that can be used by SqlAgent

AgentSubSystem

Since proxy accounts are tightly coupled with SQL Agent subsystems and we don't have a special SubSystem object, but rather an enum. The values of this enum must match the service_id value from the engine

AlertType
CategoryType
CompletionAction
CompletionResult
FindOperand

This directs evaluation of the DateJobCreated and DateJobLastModified filter properties.

FrequencyRelativeIntervals
FrequencySubDayTypes
FrequencyTypes
JobExecutionStatus
JobOutcome
JobServerType
JobStepFlags

controls parts of the behavior of the job step

JobType
MonthlyRelativeWeekDays
NotifyMethods
NotifyType

Notification type

OSRunPriority

controls execution thread scheduling for job steps executing operating system tasks

StepCompletionAction
TargetServerStatus
WeekDays