JobServer Members
The JobServer object represents the SQL Server Agent subsystem and the msdb database.
The following tables list the members exposed by the JobServer type.
.gif "ms219114.protfield(pl-pl,SQL.100).gif")
Public Properties
(see also Protected Properties )
| Name | Description | |
|---|---|---|
.gif "ms219114.pubproperty(pl-pl,SQL.100).gif") |
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. |
|
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. |
|
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. |
|
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. (inherited from 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. |
|
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. (inherited from 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. (inherited from SqlSmoObject) |
|
UserData | Gets or sets user-defined data associated with the referenced object. (inherited from SmoObjectBase) |
|
WriteOemErrorLog | Gets or sets the Boolean property value that specifies whether to write the error log to a non-Unicode file or not. |
Top
Protected Properties
| Name | Description | |
|---|---|---|
.gif "ms219114.protproperty(pl-pl,SQL.100).gif") |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (inherited from SqlSmoObject) |
|
IsTouched | Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (inherited from SqlSmoObject) |
|
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. (inherited from SqlSmoObject) |
|
ScalarResult | Gets the scalar result for the referenced object. (inherited from SqlSmoObject) |
Top
Public Methods
(see also Protected Methods )
| Name | Description | |
|---|---|---|
.gif "ms219114.pubmethod(pl-pl,SQL.100).gif") |
Alter | Updates any JobServer object property changes on an instance of SQL Server. |
|
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. |
|
CycleErrorLog | Closes and renames the current error log, and then creates a new empty error log file. |
|
Discover | (inherited from 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 | Overloaded. Enumerates a list of SQL Server Agent job history information. |
|
EnumJobs | Overloaded. Enumerates a list of information about the current job. |
|
EnumPerformanceCounters | Overloaded. Enumerates a list of SQL Server Agent performance counter information. |
|
EnumSubSystems | Enumerates a list of SQL Server Agent execution subsystems. |
|
Equals | Overloaded. (inherited from Object ) |
.gif "ms219114.static(pl-pl,SQL.100).gif") |
GetChildType | (inherited from SqlSmoObject ) |
|
GetHashCode | (inherited from Object ) |
|
GetJobByID | Returns a job with the specified ID value. |
|
GetType | (inherited from Object ) |
|
GetTypeFromUrnSkeleton | (inherited from SqlSmoObject ) |
|
Initialize | Overloaded. Initializes the object and forces the properties be loaded. (inherited from SqlSmoObject) |
|
MsxDefect | Overloaded. Ends SQL Server Agent participation in a multiserver administration group. |
|
MsxEnlist | Enlists SQL Server Agent as a target server with the specified master server in a multiserver administration. |
|
PurgeJobHistory | Overloaded. Removes all logged records of SQL Server Agent jobs. |
|
ReadErrorLog | Overloaded. Enumerates the error log. |
|
ReassignJobsByLogin | Changes ownership for any SQL Server Agent job currently owned by a SQL Server login. |
|
ReferenceEquals | (inherited from Object ) |
|
Refresh | Refreshes the object and retrieves properties when the object is next accessed. (inherited from SqlSmoObject) |
|
RemoveJobByID | Removes a job with a specified ID value. |
|
RemoveJobsByLogin | Removes a job with a specified login. |
|
Script | Overloaded. Generates a Transact-SQL script that can be used to re-create SQL Server Agent. |
|
SetHostLoginAccount | Sets the SQL Server authentication account and password used to log in to SQL Server. |
|
SetMsxAccount | Overloaded. Sets the name of the credentials used to log in to the master server in multiserver administration. |
|
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. (inherited from SqlSmoObject) |
|
Validate | (inherited from SmoObjectBase ) |
Top
Protected Methods
| Name | Description | |
|---|---|---|
.gif "ms219114.protmethod(pl-pl,SQL.100).gif") |
AddDatabaseContext | (inherited from SqlSmoObject ) |
|
AlterImpl | (inherited from SqlSmoObject ) |
|
AlterImplFinish | (inherited from SqlSmoObject ) |
|
AlterImplInit | (inherited from SqlSmoObject ) |
|
AlterImplWorker | (inherited from SqlSmoObject ) |
|
BindDefaultImpl | (inherited from SqlSmoObject ) |
|
BindRuleImpl | (inherited from SqlSmoObject ) |
|
CheckCollation | (inherited from SqlSmoObject ) |
|
CheckObjectState | Overloaded. Validates the state of the referenced object. (inherited from SqlSmoObject) |
|
CheckObjectStateImpl | (inherited from SqlSmoObject ) |
|
CheckVersion100 | (inherited from SqlSmoObject ) |
|
CheckVersion80 | Checks the validity of the object on SQL Server 2000. (inherited from SqlSmoObject) |
|
CheckVersion80SP3 | Checks the validity of the object on SQL Server 2000 SP3. (inherited from SqlSmoObject) |
|
CheckVersion90 | Check the validity of the object on SQL Server 2005. (inherited from SqlSmoObject) |
|
CheckVersionBelow90 | (inherited from SqlSmoObject ) |
|
CleanObject | (inherited from SqlSmoObject ) |
|
CreateImpl | (inherited from SqlSmoObject ) |
|
CreateImplFinish | (inherited from SqlSmoObject ) |
|
CreateImplInit | (inherited from SqlSmoObject ) |
|
DropImpl | (inherited from SqlSmoObject ) |
|
DropImplWorker | (inherited from SqlSmoObject ) |
|
EnumScriptImpl | (inherited from SqlSmoObject ) |
|
EnumScriptImplWorker | (inherited from SqlSmoObject ) |
|
Finalize | (inherited from Object ) |
|
FormatSqlVariant | (inherited from SqlSmoObject ) |
|
GenerateDataSpaceFileStreamScript | (inherited from SqlSmoObject ) |
|
GenerateDataSpaceScript | (inherited from SqlSmoObject ) |
|
GetBindDefaultScript | (inherited from SqlSmoObject ) |
|
GetBindRuleScript | (inherited from SqlSmoObject ) |
|
GetBoolParameter | Overloaded. (inherited from SqlSmoObject ) |
|
GetDateTimeParameter | (inherited from SqlSmoObject ) |
|
GetDateTimeParameterAsInt | (inherited from SqlSmoObject ) |
|
GetDBName | Gets the name of the database with which SQL Server Agent is associated. (inherited from SqlSmoObject) |
|
GetEnumParameter | (inherited from SqlSmoObject ) |
|
GetFragOptionString | (inherited from SqlSmoObject ) |
|
GetGuidParameter | (inherited from SqlSmoObject ) |
|
GetParameter | Overloaded. (inherited from SqlSmoObject ) |
|
GetPropValue | (inherited from SqlSmoObject ) |
|
GetPropValueOptional | (inherited from SqlSmoObject ) |
|
GetPropValueOptionalAllowNull | (inherited from SqlSmoObject ) |
|
GetRealValue | (inherited from SqlSmoObject ) |
|
GetScriptingOptionsForCreate | (inherited from SqlSmoObject ) |
|
GetServerName | Gets the name of the instance of SQL Server with which the object is associated. (inherited from SqlSmoObject) |
|
GetServerObject | (inherited from SqlSmoObject ) |
|
GetSqlServerVersionName | Gets the version name of the instance of SQL Server with which the object is associated. (inherited from SqlSmoObject) |
|
GetStringParameter | Overloaded. (inherited from SqlSmoObject ) |
|
GetTimeSpanParameterAsInt | (inherited from SqlSmoObject ) |
|
GetUrnRecursive | Overloaded. (inherited from SqlSmoObject ) |
|
ImplInitialize | (inherited from SqlSmoObject ) |
|
IsCollectionDirty | (inherited from SqlSmoObject ) |
|
IsObjectDirty | Verifies whether the object properties have been modified and the changes have not yet been persisted on the instance of SQL Server. (inherited from SqlSmoObject) |
|
IsObjectInitialized | Verifies whether the object has been initialized. (inherited from SqlSmoObject) |
|
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (inherited from SqlSmoObject) |
|
IsVersion80SP3 | (inherited from SqlSmoObject ) |
|
MarkDropped | (inherited from SqlSmoObject ) |
|
MarkForDropImpl | (inherited from SqlSmoObject ) |
|
MemberwiseClone | (inherited from Object ) |
|
PostAlter | (inherited from SqlSmoObject ) |
|
PostCreate | (inherited from SqlSmoObject ) |
|
PostDrop | (inherited from SqlSmoObject ) |
|
ScriptAlter | (inherited from SqlSmoObject ) |
|
ScriptCreate | (inherited from SqlSmoObject ) |
|
ScriptDdl | (inherited from SqlSmoObject ) |
|
ScriptDrop | (inherited from SqlSmoObject ) |
|
ScriptImpl | Overloaded. (inherited from SqlSmoObject ) |
|
ScriptImplWorker | (inherited from SqlSmoObject ) |
|
SetParentImpl | (inherited from SqlSmoObject ) |
|
TouchImpl | (inherited from SqlSmoObject ) |
|
Trace | (inherited from SqlSmoObject ) |
|
UnbindDefaultImpl | (inherited from SqlSmoObject ) |
|
UnbindRuleImpl | (inherited from SqlSmoObject ) |
|
UpdateCollectionState2 | (inherited from SqlSmoObject ) |
Top
Public Events
| Name | Description | |
|---|---|---|
.gif "ms219114.pubevent(pl-pl,SQL.100).gif") |
PropertyChanged | (inherited from SqlSmoObject ) |
|
PropertyMetadataChanged | (inherited from SqlSmoObject ) |
Top
Explicit Interface Implementations
| Name | Description | |
|---|---|---|
| Microsoft.SqlServer.Management.Sdk.Sfc.IAlienObject.Discover | (inherited from SqlSmoObject ) | |
| Microsoft.SqlServer.Management.Sdk.Sfc.IAlienObject.GetParent | (inherited from SqlSmoObject ) | |
| Microsoft.SqlServer.Management.Sdk.Sfc.IAlienObject.GetProperty | (inherited from SqlSmoObject ) | |
| Microsoft.SqlServer.Management.Sdk.Sfc.IAlienObject.GetUrn | (inherited from SqlSmoObject ) | |
| Microsoft.SqlServer.Management.Sdk.Sfc.IAlienObject.Resolve | (inherited from SqlSmoObject ) | |
| Microsoft.SqlServer.Management.Sdk.Sfc.IAlienObject.SetProperty | (inherited from SqlSmoObject ) | |
| Microsoft.SqlServer.Management.Sdk.Sfc.ISfcPropertyProvider.GetPropertySet | (inherited from SqlSmoObject ) |
Top