Microsoft.SqlServer.Management.Smo.Agent-Namespace

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.

  KlasseBeschreibung
Öffentliche KlasseAgentObjectBaseVerweisen Sie nicht direkt im Code auf dieses Element. Unterstützt die SQL Server-Infrastruktur. The AgentObjectBase class is a base class that is inherited by all the SQL Server Agent classes and contains common members.
Öffentliche KlasseAlertThe Alert class represents a Microsoft SQL Server Agent alert.
Öffentliche KlasseAlertCategoryThe AlertCategory class contains attributes that allow alerts to be categorized.
Öffentliche KlasseAlertCategoryCollectionThe AlertCategoryCollection class represents a collection of AlertCategory objects that represent all the categories defined on the parent object.
Öffentliche KlasseAlertCollectionThe AlertCollection class represents a collection of Alert objects that represent all the alerts defined on the parent object.
Öffentliche KlasseAlertSystemThe AlertSystem class contains system information pertaining to all alerts defined on the instance of Microsoft SQL Server.
Öffentliche KlasseCategoryBaseVerweisen Sie nicht direkt im Code auf dieses Element. Unterstützt die SQL Server-Infrastruktur. 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.
Öffentliche KlasseJobThe Job class represents a Microsoft SQL Server Agent job.
Öffentliche KlasseJobCategoryThe JobCategory class contains attributes that allow alerts to be categorized.
Öffentliche KlasseJobCategoryCollectionDie JobCategoryCollection-Klasse stellt eine Auflistung von JobCategory-Objekten dar, die alle für das übergeordnete Objekt definierten Kategorien darstellen.
Öffentliche KlasseJobCollectionThe JobCollection class represents a collection of Job objects that represent all the jobs defined on the JobServer object.
Öffentliche KlasseJobFilterThe JobFilter object is used to store information about the constraints applied to the EnumJobs method of the JobServer object.
Öffentliche KlasseJobHistoryFilterThe JobHistoryFilter object is used to store information about the constraints applied to the EnumJobHistory method of the JobServer object.
Öffentliche KlasseJobScheduleThe JobSchedule class represents a SQL Server Agent job schedule.
Öffentliche KlasseJobScheduleCollectionThe JobScheduleCollection class represents a collection of JobSchedule objects that represent all the job schedules defined on the parent object.
Öffentliche KlasseJobServerThe JobServer object represents the SQL Server Agent subsystem and the msdb database.
Öffentliche KlasseJobStepThe JobStep class represents a Microsoft SQL Server job step.
Öffentliche KlasseJobStepCollectionThe JobStepCollection class represents a collection of JobStep objects that represent all the job steps defined on the parent Job object.
Öffentliche KlasseOperatorThe Operator class represents a SQL Server Agent operator.
Öffentliche KlasseOperatorCategoryThe OperatorCategory class contains attributes that allow operators to be categorized.
Öffentliche KlasseOperatorCategoryCollectionThe OperatorCategoryCollection class represents a collection of OperatorCategory objects that represent all the categories defined on the parent object.
Öffentliche KlasseOperatorCollectionThe OperatorCollection class represents a collection of Operator objects that represent all the operators defined on the JobServer object.
Öffentliche KlasseProxyAccountThe ProxyAccount class represents a SQL Server Agent proxy account.
Öffentliche KlasseProxyAccountCollectionThe ProxyAccountCollection class represents a collection of ProxyAccount objects that represent all the proxy accounts defined on SQL Server Agent.
Öffentliche KlasseScheduleBaseVerweisen Sie nicht direkt im Code auf dieses Element. Unterstützt die SQL Server-Infrastruktur. The ScheduleBase class is a base class that is inherited by the JobSchedule class.
Öffentliche KlasseTargetServerThe TargetServer object represents a target server defined for multiserver administration on SQL Server Agent.
Öffentliche KlasseTargetServerCollectionThe TargetServerCollection class represents a collection of TargetServer objects that represent all the target servers defined on SQL Server Agent.
Öffentliche KlasseTargetServerGroupThe TargetServerGroup object that represent a target server group defined for multi-server administration on SQL Server Agent.
Öffentliche KlasseTargetServerGroupCollectionDie TargetServerGroupCollection-Klasse stellt eine Auflistung von TargetServerGroup-Objekten dar, die alle für den SQL Server-Agent definierten Zielservergruppen darstellen.

  EnumerationBeschreibung
Öffentliche EnumerationActivationOrderDie ActivationOrder-Enumeration enthält Werte, mit denen angegeben wird, wann der Trigger im Verhältnis zu anderen Triggern von Einfüge-, Aktualisierungs- oder Löschvorgängen ausgeführt wird.
Öffentliche EnumerationAgentLogLevelsThe 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.
Öffentliche EnumerationAgentMailTypeThe AgentMailType enumeration contains values that are used to specify the source of mail.
Öffentliche EnumerationAgentSubSystemThe AgentSubSystem enumeration contains values that are used to specify the Microsoft SQL Server subsystems that can be used by job steps.
Öffentliche EnumerationAlertTypeThe AlertType enumeration contains values that are used to specify the type of event or performance condition that causes alerts to be raised.
Öffentliche EnumerationCategoryTypeThe 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.
Öffentliche EnumerationCompletionActionThe CompletionAction enumeration is a list of constant values that specify the circumstances when a job completes after which another action is executed.
Öffentliche EnumerationCompletionResultThe CompletionResult enumeration is a list of constant values that specify the status on completion of a job or job step.
Öffentliche EnumerationFindOperandDie FindOperand-Enumeration stellt eine Liste von Operanden dar, mit denen die DateJobCreated-Eigenschaft und die DateJobLastModified-Eigenschaft ausgewertet werden, um einen Datumsbereich in einem Auftragsfilter anzugeben.
Öffentliche EnumerationFrequencyRelativeIntervalsThe FrequencyRelativeIntervals enumeration contains values that are used to specify the ordinal position of a recurring occurrence within a specified period.
Öffentliche EnumerationFrequencySubDayTypesDie FrequencySubDayTypes-Enumeration enthält Werte, mit denen angegeben wird, auf welche Weise die Zeitplanung innerhalb eines Tags verwaltet wird.
Öffentliche EnumerationFrequencyTypesThe FrequencyTypes enumeration contains values that are used to specify how often a schedule is executed.
Öffentliche EnumerationJobExecutionStatusThe JobExecutionStatus enumeration is a list of constant values that specify the execution status of a job or job step.
Öffentliche EnumerationJobOutcomeThe JobOutcome enumeration is a list of constant values that specify the outcome after running a job.
Öffentliche EnumerationJobServerTypeThe JobServerType enumeration is a list of constant values that specify the type of server with regard to multiserver or stand-alone administration.
Öffentliche EnumerationJobStepFlagsDie JobStepFlags-Enumeration ist eine Liste konstanter Werte, mit denen die Datei angegeben wird, an die Auftragsverlaufsinformationen angefügt werden.
Öffentliche EnumerationJobTypeThe JobType enumeration is a list of constant values that specify the location where the job is run (locally or on multiple servers).
Öffentliche EnumerationMonthlyRelativeWeekDaysDie MonthlyRelativeWeekDays-Enumeration enthält Werte, die einzelne Tage der Woche, Arbeitstage, Wochenenden oder jeden Tag angeben.
Öffentliche EnumerationNotifyMethodsThe 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.
Öffentliche EnumerationNotifyTypeThe NotifyType enumeration contains values that are used to specify the notification type that restricts the output of the Alert object's EnumNotifications method.
Öffentliche EnumerationOSRunPriorityThe OSRunPriority enumeration contains constant values that specify the levels of priority given to running the operating system.
Öffentliche EnumerationStepCompletionActionThe StepCompletionAction enumeration contains values that specify the action taken on completion of a job step.
Öffentliche EnumerationTargetServerStatusThe 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.
Öffentliche EnumerationWeekDaysThe WeekDays enumeration contains constant values that specify the days of the week.

Community-Beiträge

HINZUFÜGEN
Anzeigen: