Compartir a través de

  • Artículo

JobServer Miembros

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

El tipo JobServer expone los siguientes miembros.

Métodos

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

Principio

Campos

  Nombre Descripción
Campo protegido m_ExtendedProperties (Se hereda de SqlSmoObject).

Principio

Propiedades

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

Principio

Eventos

  Nombre Descripción
Evento público PropertyChanged (Se hereda de SqlSmoObject).
Evento público PropertyMetadataChanged (Se hereda de SqlSmoObject).

Principio

Implementaciones de interfaces explícitas

  Nombre Descripción
Implementación de interfaces explícitasMétodo privado IAlienObjectDiscover (Se hereda de SqlSmoObject).
Implementación de interfaces explícitasMétodo privado IAlienObjectGetParent (Se hereda de SqlSmoObject).
Implementación de interfaces explícitasMétodo privado IAlienObjectGetProperty (Se hereda de SqlSmoObject).
Implementación de interfaces explícitasMétodo privado ISfcPropertyProviderGetPropertySet (Se hereda de SqlSmoObject).
Implementación de interfaces explícitasMétodo privado IAlienObjectGetUrn (Se hereda de SqlSmoObject).
Implementación de interfaces explícitasMétodo privado IAlienObjectResolve (Se hereda de SqlSmoObject).
Implementación de interfaces explícitasMétodo privado IAlienObjectSetProperty (Se hereda de SqlSmoObject).

Principio