JobServer-Member
The JobServer object represents the SQL Server Agent subsystem and the msdb database.
Der JobServer-Typ macht die folgenden Member verfügbar.
Methoden
| Name | Beschreibung | |
|---|---|---|
.gif "Geschützte Methode") |
AddDatabaseContext | (Geerbt von SqlSmoObject.) |
.gif "Öffentliche Methode") |
Alter | Updates any JobServer object property changes on an instance of SQL Server. |
|
AlterImpl | (Geerbt von SqlSmoObject.) |
|
AlterImplFinish | (Geerbt von SqlSmoObject.) |
|
AlterImplInit | (Geerbt von SqlSmoObject.) |
|
AlterImplWorker | (Geerbt von SqlSmoObject.) |
|
BindDefaultImpl | (Geerbt von SqlSmoObject.) |
|
BindRuleImpl | (Geerbt von SqlSmoObject.) |
|
CheckCollation | (Geerbt von SqlSmoObject.) |
|
CheckObjectState() () () () | Validates the state of the referenced object. (Geerbt von SqlSmoObject.) |
|
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. (Geerbt von SqlSmoObject.) |
|
CheckObjectStateImpl | (Geerbt von SqlSmoObject.) |
|
CheckVersion100 | (Geerbt von SqlSmoObject.) |
|
CheckVersion80 | Checks the validity of the object on SQL Server 2000. (Geerbt von SqlSmoObject.) |
|
CheckVersion80SP3 | Checks the validity of the object on SQL Server 2000 SP3. (Geerbt von SqlSmoObject.) |
|
CheckVersion90 | Check the validity of the object on SQL Server 2005. (Geerbt von SqlSmoObject.) |
|
CheckVersionBelow90 | (Geerbt von SqlSmoObject.) |
|
CleanObject | (Geerbt von SqlSmoObject.) |
|
ClearHostLoginAccount | Clears the host login account and uses integrated security to log in to SQL Server. |
|
ClearMsxAccount | Clears the master server login account and uses integrated security to log in to the master server. |
|
CreateImpl | (Geerbt von SqlSmoObject.) |
|
CreateImplFinish | (Geerbt von SqlSmoObject.) |
|
CreateImplInit | (Geerbt von SqlSmoObject.) |
|
CycleErrorLog | Closes and renames the current error log, and then creates a new empty error log file. |
|
Discover | (Geerbt von SqlSmoObject.) |
|
DropImpl | (Geerbt von SqlSmoObject.) |
|
DropImplWorker | (Geerbt von SqlSmoObject.) |
|
DropJobByID | Removes the job with the specified ID value. |
|
DropJobsByLogin | Removes the job with the specified login name. |
|
DropJobsByServer | Removes the job with the specified server. |
|
EnumErrorLogs | Enumerates a list of SQL Server Agent error log information. |
|
EnumJobHistory() () () () | Enumerates a list of SQL Server Agent job history information. |
|
EnumJobHistory(JobHistoryFilter) | Enumerates a list of job history information. |
|
EnumJobs() () () () | Enumerates a list of information about the current job. |
|
EnumJobs(JobFilter) | Enumerates a list of information about current jobs. |
|
EnumPerformanceCounters() () () () | Enumerates a list of SQL Server Agent performance counter information. |
|
EnumPerformanceCounters(String) | Enumerates a list of SQL Server Agent performance counter information for the specified object. |
|
EnumPerformanceCounters(String, String) | Enumerates a list of SQL Server Agent performance counter information for the specified object and specified counter. |
|
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. |
|
EnumScriptImpl | (Geerbt von SqlSmoObject.) |
|
EnumScriptImplWorker | (Geerbt von SqlSmoObject.) |
|
EnumSubSystems | Enumerates a list of SQL Server Agent execution subsystems. |
|
Equals | (Geerbt von Object.) |
|
Finalize | (Geerbt von Object.) |
|
FormatSqlVariant | (Geerbt von SqlSmoObject.) |
|
GenerateDataSpaceFileStreamScript | (Geerbt von SqlSmoObject.) |
|
GenerateDataSpaceScript | (Geerbt von SqlSmoObject.) |
|
GetBindDefaultScript | (Geerbt von SqlSmoObject.) |
|
GetBindRuleScript | (Geerbt von SqlSmoObject.) |
|
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Geerbt von SqlSmoObject.) |
|
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Geerbt von SqlSmoObject.) |
|
GetDateTimeParameter | (Geerbt von SqlSmoObject.) |
|
GetDateTimeParameterAsInt | (Geerbt von SqlSmoObject.) |
|
GetDBName | Gets the database name that is associated with the object. (Geerbt von SqlSmoObject.) |
|
GetEnumParameter | (Geerbt von SqlSmoObject.) |
|
GetFragOptionString | (Geerbt von SqlSmoObject.) |
|
GetGuidParameter | (Geerbt von SqlSmoObject.) |
|
GetHashCode | (Geerbt von Object.) |
|
GetJobByID | Returns a job with the specified ID value. |
|
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Geerbt von SqlSmoObject.) |
|
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Geerbt von SqlSmoObject.) |
|
GetPropValue | (Geerbt von SqlSmoObject.) |
|
GetPropValueOptional | (Geerbt von SqlSmoObject.) |
|
GetPropValueOptionalAllowNull | (Geerbt von SqlSmoObject.) |
|
GetRealValue | (Geerbt von SqlSmoObject.) |
|
GetScriptingOptionsForCreate | (Geerbt von SqlSmoObject.) |
|
GetServerName | Gets the name of the instance of SQL Server with which the object is associated. (Geerbt von SqlSmoObject.) |
|
GetServerObject | (Geerbt von SqlSmoObject.) |
|
GetSqlServerVersionName | Gets the version name of the instance of SQL Server with which the object is associated. (Geerbt von SqlSmoObject.) |
|
GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Geerbt von SqlSmoObject.) |
|
GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Geerbt von SqlSmoObject.) |
|
GetTimeSpanParameterAsInt | (Geerbt von SqlSmoObject.) |
|
GetType | (Geerbt von Object.) |
|
GetUrnRecursive(StringBuilder) | (Geerbt von SqlSmoObject.) |
|
GetUrnRecursive(StringBuilder, UrnIdOption) | (Geerbt von SqlSmoObject.) |
|
ImplInitialize | (Geerbt von SqlSmoObject.) |
|
Initialize() () () () | Initializes the object and forces the properties be loaded. (Geerbt von SqlSmoObject.) |
|
Initialize(Boolean) | Initializes the object and forces the properties be loaded. (Geerbt von SqlSmoObject.) |
|
IsObjectDirty | Verifies whether the object properties have been modified and the changes have not yet been persisted on the instance of SQL Server. (Geerbt von SqlSmoObject.) |
|
IsObjectInitialized | Verifies whether the object has been initialized. (Geerbt von SqlSmoObject.) |
|
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (Geerbt von SqlSmoObject.) |
|
IsVersion80SP3 | (Geerbt von SqlSmoObject.) |
|
MarkDropped | (Geerbt von SqlSmoObject.) |
|
MarkForDropImpl | (Geerbt von SqlSmoObject.) |
|
MemberwiseClone | (Geerbt von Object.) |
|
MsxDefect() () () () | Ends SQL Server Agent participation in a multiserver administration group. |
|
MsxDefect(Boolean) | Ends SQL Server Agent participation in a multiserver administration group with the option to force defection. |
|
MsxEnlist | Enlists SQL Server Agent as a target server with the specified master server in a multiserver administration. |
|
PostAlter | (Geerbt von SqlSmoObject.) |
|
PostCreate | (Geerbt von SqlSmoObject.) |
|
PostDrop | (Geerbt von SqlSmoObject.) |
|
PurgeJobHistory() () () () | Removes all logged records of SQL Server Agent jobs. |
|
PurgeJobHistory(JobHistoryFilter) | Removes all logged records of SQL Server Agent jobs as specified by a filter. |
|
ReadErrorLog() () () () | Enumerates the error log. |
|
ReadErrorLog(Int32) | Enumerates the error log. |
|
ReassignJobsByLogin | Changes ownership for any SQL Server Agent job currently owned by a SQL Server login. |
|
Refresh | Refreshes the object and retrieves properties when the object is next accessed. (Geerbt von SqlSmoObject.) |
|
RemoveJobByID | Removes a job with a specified ID value. |
|
RemoveJobsByLogin | Removes a job with a specified login. |
|
Script() () () () | Generates a Transact-SQL script that can be used to re-create SQL Server Agent. |
|
Script(ScriptingOptions) | Generates a Transact-SQL script that can be used to re-create SQL Server Agent as specified by the scripting options. |
|
ScriptAlter | (Geerbt von SqlSmoObject.) |
|
ScriptCreate | (Geerbt von SqlSmoObject.) |
|
ScriptDdl | (Geerbt von SqlSmoObject.) |
|
ScriptDrop | (Geerbt von SqlSmoObject.) |
|
ScriptImpl() () () () | (Geerbt von SqlSmoObject.) |
|
ScriptImpl(ScriptingOptions) | (Geerbt von SqlSmoObject.) |
|
ScriptImplWorker | (Geerbt von SqlSmoObject.) |
|
SetHostLoginAccount | Sets the SQL Server authentication account and password used to log in to SQL Server. |
|
SetMsxAccount(String) | Sets the name of the credentials used to log in to the master server in multiserver administration. |
|
SetMsxAccount(String, String) | Sets the name of the credentials used to log in to the master server in multiserver administration. |
|
SetParentImpl | (Geerbt von SqlSmoObject.) |
|
StartMonitor | Starts monitoring the local SQL Server Agent Service by an instance of SQL Server. |
|
StopMonitor | Ends monitoring the local SQL Server Agent Service by an instance of SQL Server. |
|
TestMailProfile | Tests the validity of an e-mail profile. |
|
TestNetSend | Tests the validity of a net send address. |
|
ToString | Returns a String that represents the referenced object. (Geerbt von SqlSmoObject.) |
|
TouchImpl | (Geerbt von SqlSmoObject.) |
|
UnbindDefaultImpl | (Geerbt von SqlSmoObject.) |
|
UnbindRuleImpl | (Geerbt von SqlSmoObject.) |
|
Validate | (Geerbt von SmoObjectBase.) |
Zum Anfang
.gif "Geschütztes Feld")
Eigenschaften
| Name | Beschreibung | |
|---|---|---|
.gif "Öffentliche Eigenschaft") |
AgentDomainGroup | Gets the SQL Server Agent domain group. |
|
AgentLogLevel | Gets or sets the type of messages that are logged by SQL Server Agent. |
|
AgentMailType | Gets or sets the mail type for SQL Server Agent. |
|
AgentShutdownWaitTime | Gets or sets the time that SQL Server Agent waits for jobs to complete execution before shutting down. |
|
AlertCategories | Represents a collection of AlertCategory objects. Each AlertCategory object represents an alert category defined on SQL Server Agent. |
|
Alerts | Represents a collection of Alert objects. Each Alert object represents an alert defined on SQL Server Agent. |
|
AlertSystem | The AlertSystem object stores information that applies to all the alerts defined on SQL Server Agent. |
|
DatabaseMailProfile | Gets or sets a Database Mail profile. |
|
ErrorLogFile | Gets or sets the name and path of the file in which SQL Server Agent records errors. |
.gif "Geschützte Eigenschaft") |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Geerbt von SqlSmoObject.) |
|
HostLoginName | Gets or sets the login used to log in to SQL Server. |
|
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. |
|
IdleCpuPercentage | Gets or sets the CPU idle percentage threshold that the processor is required to achieve before it is considered idle. |
|
IsCpuPollingEnabled | Gets or sets the Boolean property value that specifies whether CPU polling is enabled. |
|
IsTouched | Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (Geerbt von SqlSmoObject.) |
|
JobCategories | Represents a collection of JobCategory objects. Each JobCategory object represents a job category defined on SQL Server Agent. |
|
Jobs | Represents a collection of Job objects. Each Job object represents a job defined on SQL Server Agent. |
|
JobServerType | Gets or sets the type of job server with regard to multiserver administration. |
|
LocalHostAlias | Gets or sets the local host alias that is used to connect to the local instance of SQL Server. |
|
LoginTimeout | Gets or sets the number of seconds after which an attempt to connect times out. |
|
MaximumHistoryRows | Gets or sets the maximum number of history rows retained. |
|
MaximumJobHistoryRows | Gets or sets the maximum number of history rows retained per job. |
|
MsxAccountCredentialName | Gets or sets the Windows account required to connect to the master server using Windows Authentication. |
|
MsxAccountName | Gets or sets the login required to connect to the master server using SQL Server Authentication. |
|
MsxServerName | Gets or sets the name of the master server participating in multiserver administration. |
|
Name | Gets the name of the SQL Server Agent service. |
|
NetSendRecipient | Gets or sets the recipient of net send messages. |
|
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. (Geerbt von SqlSmoObject.) |
|
OperatorCategories | Represents a collection of OperatorCategory objects. Each OperatorCategory object represents an operator category defined on SQL Server Agent. |
|
Operators | Represents a collection of Operator objects. Each Operator object represents an operator defined on SQL Server Agent. |
|
Parent | Gets the Server object that is the parent of the JobServer object. |
|
Properties | Gets a collection of Property objects that represent the object properties. (Geerbt von SqlSmoObject.) |
|
ProxyAccounts | Represents a collection of ProxyAccount objects. Each ProxyAccount object represents a proxy account defined on SQL Server Agent. |
|
ReplaceAlertTokensEnabled | |
|
SaveInSentFolder | Gets or sets the Boolean property value that specifies whether the notifications are saved. |
|
ScalarResult | Gets the scalar result for the referenced object. (Geerbt von SqlSmoObject.) |
|
ServiceAccount | Gets the account under which the SQL Server Agent service runs |
|
ServiceStartMode | Gets the mode used to start the SQL Server Agent service. |
|
SharedSchedules | Represents a collection of JobSchedule objects. Each JobSchedule object represents a shared schedule defined on SQL Server Agent. |
|
SqlAgentAutoStart | Gets or sets the Boolean property value that specifies whether SQL Server Agent is automatically started. |
|
SqlAgentMailProfile | Gets or sets a SQL Server Agent mail profile. |
|
SqlAgentRestart | Gets or sets the Boolean property value that specifies whether SQL Server Agent is monitored and restarted if it stops. |
|
SqlServerRestart | Gets or sets the Boolean property value that specifies whether the SQL Server Service is monitored and restarted if it stops. |
|
State | Gets the state of the referenced object. (Geerbt von SmoObjectBase.) |
|
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. |
|
TargetServerGroups | Represents a collection of TargetServerGroup objects. Each TargetServerGroup object represents a target server group defined on SQL Server Agent. |
|
TargetServers | Represents a collection of TargetServer objects. Each TargetServer object represents a target server defined on SQL Server Agent. |
|
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Geerbt von SqlSmoObject.) |
|
UserData | Gets or sets user-defined data associated with the referenced object. (Geerbt von SmoObjectBase.) |
|
WriteOemErrorLog | Gets or sets the Boolean property value that specifies whether to write the error log to a non-Unicode file or not. |
Zum Anfang
Ereignisse
| Name | Beschreibung | |
|---|---|---|
.gif "Öffentliches Ereignis") |
PropertyChanged | (Geerbt von SqlSmoObject.) |
|
PropertyMetadataChanged | (Geerbt von SqlSmoObject.) |
Zum Anfang
Explizite Schnittstellenimplementierungen
| Name | Beschreibung | |
|---|---|---|
.gif "Explizite Schnittstellenimplementierung") .gif "Private Methode") |
IAlienObjectDiscover | (Geerbt von SqlSmoObject.) |
|
IAlienObjectGetParent | (Geerbt von SqlSmoObject.) |
|
IAlienObjectGetProperty | (Geerbt von SqlSmoObject.) |
|
ISfcPropertyProviderGetPropertySet | (Geerbt von SqlSmoObject.) |
|
IAlienObjectGetUrn | (Geerbt von SqlSmoObject.) |
|
IAlienObjectResolve | (Geerbt von SqlSmoObject.) |
|
IAlienObjectSetProperty | (Geerbt von SqlSmoObject.) |
Zum Anfang