Microsoft.SqlServer.Management.Smo.Agent 命名空间

The Microsoft.SqlServer.Management.Smo.Agent namespace contains classes that represent the SQL Server Agent.

The Microsoft.SqlServer.Management.Smo.Agent namespace represents the SQL Server Agent. After a connection to an instance of SQL Server has been established by using the Server object variable, you can use the objects in the Microsoft.SqlServer.Management.Smo.Agent namespace to manage the SQL Server Agent.

The Microsoft.SqlServer.Management.Smo.Agent namespace resides in the Microsoft.SqlServer.Smo.dll assembly file. Also, some of the enumeration classes are in the Microsoft.SqlServer.SqlEnum.dll and Microsoft.SqlServer.SmoEnum.dll assembly files. You will have to import all three files to access the classes in the Microsoft.SqlServer.Management.Smo.Agent namespace.

By using the Microsoft.SqlServer.Management.Smo.Agent namespace, you can do the following:

  • View and modify SQL Server Agent settings.

  • Set up and manage operators.

  • Set up and manage alerts based on system messages or performance conditions.

  • Set up and manage jobs with multiple steps and schedules.

  • Manage proxy accounts for the subsystems on which jobs run.

  • Manage jobs that run on multiple servers.

  说明
公共类 AgentObjectBase 不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 The AgentObjectBase class is a base class that is inherited by all the SQL Server Agent classes and contains common members.
公共类 Alert The Alert class represents a Microsoft SQL Server Agent alert.
公共类 AlertCategory The AlertCategory class contains attributes that allow alerts to be categorized.
公共类 AlertCategoryCollection The AlertCategoryCollection class represents a collection of AlertCategory objects that represent all the categories defined on the parent object.
公共类 AlertCollection The AlertCollection class represents a collection of Alert objects that represent all the alerts defined on the parent object.
公共类 AlertSystem The AlertSystem class contains system information pertaining to all alerts defined on the instance of Microsoft SQL Server.
公共类 CategoryBase 不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 The CategoryBase class is a base class that is used in the construction of the JobCategory class, the OperatorCategory class, and the AlertCategory class. It contains functionality that is common to all three category classes.
公共类 Job The Job class represents a Microsoft SQL Server Agent job.
公共类 JobCategory The JobCategory class contains attributes that allow alerts to be categorized.
公共类 JobCategoryCollection JobCategoryCollection 类表示 JobCategory 对象的集合,这些对象表示在父对象上定义的所有类别。
公共类 JobCollection The JobCollection class represents a collection of Job objects that represent all the jobs defined on the JobServer object.
公共类 JobFilter The JobFilter object is used to store information about the constraints applied to the EnumJobs method of the JobServer object.
公共类 JobHistoryFilter The JobHistoryFilter object is used to store information about the constraints applied to the EnumJobHistory method of the JobServer object.
公共类 JobSchedule The JobSchedule class represents a SQL Server Agent job schedule.
公共类 JobScheduleCollection The JobScheduleCollection class represents a collection of JobSchedule objects that represent all the job schedules defined on the parent object.
公共类 JobServer The JobServer object represents the SQL Server Agent subsystem and the msdb database.
公共类 JobStep The JobStep class represents a Microsoft SQL Server job step.
公共类 JobStepCollection The JobStepCollection class represents a collection of JobStep objects that represent all the job steps defined on the parent Job object.
公共类 Operator The Operator class represents a SQL Server Agent operator.
公共类 OperatorCategory The OperatorCategory class contains attributes that allow operators to be categorized.
公共类 OperatorCategoryCollection The OperatorCategoryCollection class represents a collection of OperatorCategory objects that represent all the categories defined on the parent object.
公共类 OperatorCollection The OperatorCollection class represents a collection of Operator objects that represent all the operators defined on the JobServer object.
公共类 ProxyAccount The ProxyAccount class represents a SQL Server Agent proxy account.
公共类 ProxyAccountCollection The ProxyAccountCollection class represents a collection of ProxyAccount objects that represent all the proxy accounts defined on SQL Server Agent.
公共类 ScheduleBase 不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 The ScheduleBase class is a base class that is inherited by the JobSchedule class.
公共类 TargetServer The TargetServer object represents a target server defined for multiserver administration on SQL Server Agent.
公共类 TargetServerCollection The TargetServerCollection class represents a collection of TargetServer objects that represent all the target servers defined on SQL Server Agent.
公共类 TargetServerGroup The TargetServerGroup object that represent a target server group defined for multi-server administration on SQL Server Agent.
公共类 TargetServerGroupCollection TargetServerGroupCollection 类表示 TargetServerGroup 对象的集合,这些对象表示在 SQL Server 代理上定义的所有目标服务器组。

枚举

  枚举 说明
公共枚举 ActivationOrder ActivationOrder 枚举包含的值用于指定何时针对附加到给定插入、更新或删除操作的其他触发器运行触发器。
公共枚举 AgentLogLevels The AgentLogLevels enumeration contains values that are used to specify the type of errors or messages that are logged by SQL Server. This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.
公共枚举 AgentMailType The AgentMailType enumeration contains values that are used to specify the source of mail.
公共枚举 AgentSubSystem The AgentSubSystem enumeration contains values that are used to specify the Microsoft SQL Server subsystems that can be used by job steps.
公共枚举 AlertType The AlertType enumeration contains values that are used to specify the type of event or performance condition that causes alerts to be raised.
公共枚举 CategoryType The CategoryType enumeration is a list of constant values that specify the type of category, such as whether the category refers to local jobs or multiserver administration.
公共枚举 CompletionAction The CompletionAction enumeration is a list of constant values that specify the circumstances when a job completes after which another action is executed.
公共枚举 CompletionResult The CompletionResult enumeration is a list of constant values that specify the status on completion of a job or job step.
公共枚举 FindOperand FindOperand 枚举表示操作数的列表,这些操作数用来计算 DateJobCreatedDateJobLastModified 属性以指定作业筛选器中的日期范围。
公共枚举 FrequencyRelativeIntervals The FrequencyRelativeIntervals enumeration contains values that are used to specify the ordinal position of a recurring occurrence within a specified period.
公共枚举 FrequencySubDayTypes FrequencySubDayTypes 枚举包含的值用于指定在一天期间内管理计划编制的方式。
公共枚举 FrequencyTypes The FrequencyTypes enumeration contains values that are used to specify how often a schedule is executed.
公共枚举 JobExecutionStatus The JobExecutionStatus enumeration is a list of constant values that specify the execution status of a job or job step.
公共枚举 JobOutcome The JobOutcome enumeration is a list of constant values that specify the outcome after running a job.
公共枚举 JobServerType The JobServerType enumeration is a list of constant values that specify the type of server with regard to multiserver or stand-alone administration.
公共枚举 JobStepFlags JobStepFlags 枚举是常量值的列表,这些值用于指定要向其追加作业历史记录信息的文件。
公共枚举 JobType The JobType enumeration is a list of constant values that specify the location where the job is run (locally or on multiple servers).
公共枚举 MonthlyRelativeWeekDays MonthlyRelativeWeekDays 枚举包含指定一周中的日期、工作日、周末或每天的值。
公共枚举 NotifyMethods The NotifyMethods enumeration contains values that specify the method used to notify operators in an alert or a job. This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.
公共枚举 NotifyType The NotifyType enumeration contains values that are used to specify the notification type that restricts the output of the Alert object's EnumNotifications method.
公共枚举 OSRunPriority The OSRunPriority enumeration contains constant values that specify the levels of priority given to running the operating system.
公共枚举 StepCompletionAction The StepCompletionAction enumeration contains values that specify the action taken on completion of a job step.
公共枚举 TargetServerStatus The TargetServerStatus enumeration contains values that specify the status of a target server. This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.
公共枚举 WeekDays The WeekDays enumeration contains constant values that specify the days of the week.