Compartilhar via

  • Artigo

Membros JobServer

The JobServer object represents the SQL Server Agent subsystem and the msdb database.

O tipo JobServer expõe os seguintes membros.

Métodos

  Nome Descrição
Método protegido AddDatabaseContext (Herdado de SqlSmoObject.)
Método público Alter Updates any JobServer object property changes on an instance of SQL Server. 
Método protegido AlterImpl (Herdado de SqlSmoObject.)
Método protegido AlterImplFinish (Herdado de SqlSmoObject.)
Método protegido AlterImplInit (Herdado de SqlSmoObject.)
Método protegido AlterImplWorker (Herdado de SqlSmoObject.)
Método protegido BindDefaultImpl (Herdado de SqlSmoObject.)
Método protegido BindRuleImpl (Herdado de SqlSmoObject.)
Método protegido CheckCollation (Herdado de SqlSmoObject.)
Método protegido CheckObjectState() () () () Validates the state of the referenced object. (Herdado de SqlSmoObject.)
Método protegido CheckObjectState(Boolean) Validates the state of the referenced object with the option to specify that an exception is thrown if the object is not yet created. (Herdado de SqlSmoObject.)
Método protegido CheckObjectStateImpl (Herdado de SqlSmoObject.)
Método protegido CheckVersion100 (Herdado de SqlSmoObject.)
Método protegido CheckVersion80 Checks the validity of the object on SQL Server 2000. (Herdado de SqlSmoObject.)
Método protegido CheckVersion80SP3 Checks the validity of the object on SQL Server 2000 SP3. (Herdado de SqlSmoObject.)
Método protegido CheckVersion90 Check the validity of the object on SQL Server 2005. (Herdado de SqlSmoObject.)
Método protegido CheckVersionBelow90 (Herdado de SqlSmoObject.)
Método protegido CleanObject (Herdado de SqlSmoObject.)
Método público ClearHostLoginAccount Clears the host login account and uses integrated security to log in to SQL Server.
Método público ClearMsxAccount Clears the master server login account and uses integrated security to log in to the master server.
Método protegido CreateImpl (Herdado de SqlSmoObject.)
Método protegido CreateImplFinish (Herdado de SqlSmoObject.)
Método protegido CreateImplInit (Herdado de SqlSmoObject.)
Método público CycleErrorLog Closes and renames the current error log, and then creates a new empty error log file.
Método público Discover (Herdado de SqlSmoObject.)
Método protegido DropImpl (Herdado de SqlSmoObject.)
Método protegido DropImplWorker (Herdado de SqlSmoObject.)
Método público DropJobByID Removes the job with the specified ID value.
Método público DropJobsByLogin Removes the job with the specified login name.
Método público DropJobsByServer Removes the job with the specified server.
Método público EnumErrorLogs Enumerates a list of SQL Server Agent error log information.
Método público EnumJobHistory() () () () Enumerates a list of SQL Server Agent job history information.
Método público EnumJobHistory(JobHistoryFilter) Enumerates a list of job history information.
Método público EnumJobs() () () () Enumerates a list of information about the current job.
Método público EnumJobs(JobFilter) Enumerates a list of information about current jobs.
Método público EnumPerformanceCounters() () () () Enumerates a list of SQL Server Agent performance counter information.
Método público EnumPerformanceCounters(String) Enumerates a list of SQL Server Agent performance counter information for the specified object.
Método público EnumPerformanceCounters(String, String) Enumerates a list of SQL Server Agent performance counter information for the specified object and specified counter.
Método público EnumPerformanceCounters(String, String, String) Enumerates a list of SQL Server Agent performance counter information for the specified object, specified counter, and specified instance of SQL Server.
Método protegido EnumScriptImpl (Herdado de SqlSmoObject.)
Método protegido EnumScriptImplWorker (Herdado de SqlSmoObject.)
Método público EnumSubSystems Enumerates a list of SQL Server Agent execution subsystems.
Método público Equals (Herdado de Object.)
Método protegido Finalize (Herdado de Object.)
Método protegido FormatSqlVariant (Herdado de SqlSmoObject.)
Método protegido GenerateDataSpaceFileStreamScript (Herdado de SqlSmoObject.)
Método protegido GenerateDataSpaceScript (Herdado de SqlSmoObject.)
Método protegido GetBindDefaultScript (Herdado de SqlSmoObject.)
Método protegido GetBindRuleScript (Herdado de SqlSmoObject.)
Método protegido GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%) (Herdado de SqlSmoObject.)
Método protegido GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) (Herdado de SqlSmoObject.)
Método protegido GetDateTimeParameter (Herdado de SqlSmoObject.)
Método protegido GetDateTimeParameterAsInt (Herdado de SqlSmoObject.)
Método protegido GetDBName Gets the database name that is associated with the object. (Herdado de SqlSmoObject.)
Método protegido GetEnumParameter (Herdado de SqlSmoObject.)
Método protegido GetFragOptionString (Herdado de SqlSmoObject.)
Método protegido GetGuidParameter (Herdado de SqlSmoObject.)
Método público GetHashCode (Herdado de Object.)
Método público GetJobByID Returns a job with the specified ID value.
Método protegido GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%) (Herdado de SqlSmoObject.)
Método protegido GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) (Herdado de SqlSmoObject.)
Método protegido GetPropValue (Herdado de SqlSmoObject.)
Método protegido GetPropValueOptional (Herdado de SqlSmoObject.)
Método protegido GetPropValueOptionalAllowNull (Herdado de SqlSmoObject.)
Método protegido GetRealValue (Herdado de SqlSmoObject.)
Método protegido GetScriptingOptionsForCreate (Herdado de SqlSmoObject.)
Método protegido GetServerName Gets the name of the instance of SQL Server with which the object is associated. (Herdado de SqlSmoObject.)
Método protegido GetServerObject (Herdado de SqlSmoObject.)
Método protegido GetSqlServerVersionName Gets the version name of the instance of SQL Server with which the object is associated. (Herdado de SqlSmoObject.)
Método protegido GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%) (Herdado de SqlSmoObject.)
Método protegido GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) (Herdado de SqlSmoObject.)
Método protegido GetTimeSpanParameterAsInt (Herdado de SqlSmoObject.)
Método público GetType (Herdado de Object.)
Método protegido GetUrnRecursive(StringBuilder) (Herdado de SqlSmoObject.)
Método protegido GetUrnRecursive(StringBuilder, UrnIdOption) (Herdado de SqlSmoObject.)
Método protegido ImplInitialize (Herdado de SqlSmoObject.)
Método público Initialize() () () () Initializes the object and forces the properties be loaded. (Herdado de SqlSmoObject.)
Método público Initialize(Boolean) Initializes the object and forces the properties be loaded. (Herdado de SqlSmoObject.)
Método protegido IsObjectDirty Verifies whether the object properties have been modified and the changes have not yet been persisted on the instance of SQL Server. (Herdado de SqlSmoObject.)
Método protegido IsObjectInitialized Verifies whether the object has been initialized. (Herdado de SqlSmoObject.)
Método protegido IsObjectInSpace Verifies whether the object is isolated or connected to the instance of SQL Server. (Herdado de SqlSmoObject.)
Método protegido IsVersion80SP3 (Herdado de SqlSmoObject.)
Método protegido MarkDropped (Herdado de SqlSmoObject.)
Método protegido MarkForDropImpl (Herdado de SqlSmoObject.)
Método protegido MemberwiseClone (Herdado de Object.)
Método público MsxDefect() () () () Ends SQL Server Agent participation in a multiserver administration group. 
Método público MsxDefect(Boolean) Ends SQL Server Agent participation in a multiserver administration group with the option to force defection.
Método público MsxEnlist Enlists SQL Server Agent as a target server with the specified master server in a multiserver administration.
Método protegido PostAlter (Herdado de SqlSmoObject.)
Método protegido PostCreate (Herdado de SqlSmoObject.)
Método protegido PostDrop (Herdado de SqlSmoObject.)
Método público PurgeJobHistory() () () () Removes all logged records of SQL Server Agent jobs.
Método público PurgeJobHistory(JobHistoryFilter) Removes all logged records of SQL Server Agent jobs as specified by a filter.
Método público ReadErrorLog() () () () Enumerates the error log.
Método público ReadErrorLog(Int32) Enumerates the error log.
Método público ReassignJobsByLogin Changes ownership for any SQL Server Agent job currently owned by a SQL Server login.
Método público Refresh Refreshes the object and retrieves properties when the object is next accessed. (Herdado de SqlSmoObject.)
Método público RemoveJobByID Removes a job with a specified ID value.
Método público RemoveJobsByLogin Removes a job with a specified login.
Método público Script() () () () Generates a Transact-SQL script that can be used to re-create SQL Server Agent.
Método público Script(ScriptingOptions) Generates a Transact-SQL script that can be used to re-create SQL Server Agent as specified by the scripting options.
Método protegido ScriptAlter (Herdado de SqlSmoObject.)
Método protegido ScriptCreate (Herdado de SqlSmoObject.)
Método protegido ScriptDdl (Herdado de SqlSmoObject.)
Método protegido ScriptDrop (Herdado de SqlSmoObject.)
Método protegido ScriptImpl() () () () (Herdado de SqlSmoObject.)
Método protegido ScriptImpl(ScriptingOptions) (Herdado de SqlSmoObject.)
Método protegido ScriptImplWorker (Herdado de SqlSmoObject.)
Método público SetHostLoginAccount Sets the SQL Server authentication account and password used to log in to SQL Server.
Método público SetMsxAccount(String) Sets the name of the credentials used to log in to the master server in multiserver administration.
Método público SetMsxAccount(String, String) Sets the name of the credentials used to log in to the master server in multiserver administration.
Método protegido SetParentImpl (Herdado de SqlSmoObject.)
Método público StartMonitor Starts monitoring the local SQL Server Agent Service by an instance of SQL Server.
Método público StopMonitor Ends monitoring the local SQL Server Agent Service by an instance of SQL Server.
Método público TestMailProfile Tests the validity of an e-mail profile.
Método público TestNetSend Tests the validity of a net send address.
Método público ToString Returns a String that represents the referenced object. (Herdado de SqlSmoObject.)
Método protegido TouchImpl (Herdado de SqlSmoObject.)
Método protegido UnbindDefaultImpl (Herdado de SqlSmoObject.)
Método protegido UnbindRuleImpl (Herdado de SqlSmoObject.)
Método público Validate (Herdado de SmoObjectBase.)

Início

Campos

  Nome Descrição
Campo protegido m_ExtendedProperties (Herdado de SqlSmoObject.)

Início

Propriedades

  Nome Descrição
Propriedade pública AgentDomainGroup Gets the SQL Server Agent domain group.
Propriedade pública AgentLogLevel Gets or sets the type of messages that are logged by SQL Server Agent.
Propriedade pública AgentMailType Gets or sets the mail type for SQL Server Agent.
Propriedade pública AgentShutdownWaitTime Gets or sets the time that SQL Server Agent waits for jobs to complete execution before shutting down.
Propriedade pública AlertCategories Represents a collection of AlertCategory objects. Each AlertCategory object represents an alert category defined on SQL Server Agent.
Propriedade pública Alerts Represents a collection of Alert objects. Each Alert object represents an alert defined on SQL Server Agent.
Propriedade pública AlertSystem The AlertSystem object stores information that applies to all the alerts defined on SQL Server Agent.
Propriedade pública DatabaseMailProfile Gets or sets a Database Mail profile.
Propriedade pública ErrorLogFile Gets or sets the name and path of the file in which SQL Server Agent records errors.
Propriedade protegida ExecuteForScalar Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Herdado de SqlSmoObject.)
Propriedade pública HostLoginName Gets or sets the login used to log in to SQL Server.
Propriedade pública IdleCpuDuration Gets or sets the length of time in seconds that the processor must have to maintain the CPU idle percentage value before the processor is considered idle.
Propriedade pública IdleCpuPercentage Gets or sets the CPU idle percentage threshold that the processor is required to achieve before it is considered idle.
Propriedade pública IsCpuPollingEnabled Gets or sets the Boolean property value that specifies whether CPU polling is enabled.
Propriedade protegida IsTouched Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (Herdado de SqlSmoObject.)
Propriedade pública JobCategories Represents a collection of JobCategory objects. Each JobCategory object represents a job category defined on SQL Server Agent.
Propriedade pública Jobs Represents a collection of Job objects. Each Job object represents a job defined on SQL Server Agent.
Propriedade pública JobServerType Gets or sets the type of job server with regard to multiserver administration.
Propriedade pública LocalHostAlias Gets or sets the local host alias that is used to connect to the local instance of SQL Server.
Propriedade pública LoginTimeout Gets or sets the number of seconds after which an attempt to connect times out.
Propriedade pública MaximumHistoryRows Gets or sets the maximum number of history rows retained.
Propriedade pública MaximumJobHistoryRows Gets or sets the maximum number of history rows retained per job.
Propriedade pública MsxAccountCredentialName Gets or sets the Windows account required to connect to the master server using Windows Authentication.
Propriedade pública MsxAccountName Gets or sets the login required to connect to the master server using SQL Server Authentication.
Propriedade pública MsxServerName Gets or sets the name of the master server participating in multiserver administration.
Propriedade pública Name Gets the name of the SQL Server Agent service.
Propriedade pública NetSendRecipient Gets or sets the recipient of net send messages.
Propriedade protegida ObjectInSpace Gets the Boolean property value that specifies whether the object exists in isolation, or whether it is directly or indirectly connected to the instance of SQL Server. (Herdado de SqlSmoObject.)
Propriedade pública OperatorCategories Represents a collection of OperatorCategory objects. Each OperatorCategory object represents an operator category defined on SQL Server Agent.
Propriedade pública Operators Represents a collection of Operator objects. Each Operator object represents an operator defined on SQL Server Agent.
Propriedade pública Parent Gets the Server object that is the parent of the JobServer object.
Propriedade pública Properties Gets a collection of Property objects that represent the object properties. (Herdado de SqlSmoObject.)
Propriedade pública ProxyAccounts Represents a collection of ProxyAccount objects. Each ProxyAccount object represents a proxy account defined on SQL Server Agent.
Propriedade pública ReplaceAlertTokensEnabled
Propriedade pública SaveInSentFolder Gets or sets the Boolean property value that specifies whether the notifications are saved.
Propriedade protegida ScalarResult Gets the scalar result for the referenced object. (Herdado de SqlSmoObject.)
Propriedade pública ServiceAccount Gets the account under which the SQL Server Agent service runs
Propriedade pública ServiceStartMode Gets the mode used to start the SQL Server Agent service.
Propriedade pública SharedSchedules Represents a collection of JobSchedule objects. Each JobSchedule object represents a shared schedule defined on SQL Server Agent.
Propriedade pública SqlAgentAutoStart Gets or sets the Boolean property value that specifies whether SQL Server Agent is automatically started.
Propriedade pública SqlAgentMailProfile Gets or sets a SQL Server Agent mail profile.
Propriedade pública SqlAgentRestart Gets or sets the Boolean property value that specifies whether SQL Server Agent is monitored and restarted if it stops.
Propriedade pública SqlServerRestart Gets or sets the Boolean property value that specifies whether the SQL Server Service is monitored and restarted if it stops.
Propriedade pública State Gets the state of the referenced object. (Herdado de SmoObjectBase.)
Propriedade pública SysAdminOnly Gets the Boolean property value that specifies whether CmdExec and ActiveX commands can only be executed by members of the sysadmin fixed server role.
Propriedade pública TargetServerGroups Represents a collection of TargetServerGroup objects. Each TargetServerGroup object represents a target server group defined on SQL Server Agent.
Propriedade pública TargetServers Represents a collection of TargetServer objects. Each TargetServer object represents a target server defined on SQL Server Agent.
Propriedade pública Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Herdado de SqlSmoObject.)
Propriedade pública UserData Gets or sets user-defined data associated with the referenced object. (Herdado de SmoObjectBase.)
Propriedade pública WriteOemErrorLog Gets or sets the Boolean property value that specifies whether to write the error log to a non-Unicode file or not.

Início

Eventos

  Nome Descrição
Evento público PropertyChanged (Herdado de SqlSmoObject.)
Evento público PropertyMetadataChanged (Herdado de SqlSmoObject.)

Início

Implementações de interface explícitas

  Nome Descrição
Implementação de interface explícitaMétodo particular IAlienObjectDiscover (Herdado de SqlSmoObject.)
Implementação de interface explícitaMétodo particular IAlienObjectGetParent (Herdado de SqlSmoObject.)
Implementação de interface explícitaMétodo particular IAlienObjectGetProperty (Herdado de SqlSmoObject.)
Implementação de interface explícitaMétodo particular ISfcPropertyProviderGetPropertySet (Herdado de SqlSmoObject.)
Implementação de interface explícitaMétodo particular IAlienObjectGetUrn (Herdado de SqlSmoObject.)
Implementação de interface explícitaMétodo particular IAlienObjectResolve (Herdado de SqlSmoObject.)
Implementação de interface explícitaMétodo particular IAlienObjectSetProperty (Herdado de SqlSmoObject.)

Início