JobServer Members
Include Protected Members
Include Inherited Members
The JobServer object represents the SQL Server Agent subsystem and the msdb database.
The JobServer type exposes the following members.
Methods
| Name | Description | |
|---|---|---|
.gif "Protected method") |
AddDatabaseContext(StringCollection) | (Inherited from SqlSmoObject.) |
.gif "Public method") |
Alter() | Updates any JobServer object property changes on an instance of SQL Server. |
|
AlterImpl() | (Inherited from SqlSmoObject.) |
|
AlterImplFinish(StringCollection, ScriptingOptions) | (Inherited from SqlSmoObject.) |
|
AlterImplInit(StringCollection%, ScriptingOptions%) | (Inherited from SqlSmoObject.) |
|
AlterImplWorker() | (Inherited from SqlSmoObject.) |
|
BindDefaultImpl(String, String, Boolean) | (Inherited from SqlSmoObject.) |
|
BindRuleImpl(String, String, Boolean) | (Inherited from SqlSmoObject.) |
|
CheckCollation(String, ScriptingOptions) | (Inherited from SqlSmoObject.) |
|
CheckObjectState() | Validates the state of the referenced object. (Inherited from 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. (Inherited from SqlSmoObject.) |
|
CheckObjectStateImpl(Boolean) | (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.) |
|
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() | (Inherited from SqlSmoObject.) |
|
CreateImplFinish(StringCollection, ScriptingOptions) | (Inherited from SqlSmoObject.) |
|
CreateImplInit(StringCollection%, ScriptingOptions%) | (Inherited from SqlSmoObject.) |
|
CycleErrorLog() | Closes and renames the current error log, and then creates a new empty error log file. |
|
Discover() | (Inherited from SqlSmoObject.) |
|
DropImpl() | (Inherited from SqlSmoObject.) |
|
DropImplWorker(Urn%) | (Inherited from SqlSmoObject.) |
|
DropJobByID(Guid) | Removes the job with the specified ID value. |
|
DropJobsByLogin(String) | Removes the job with the specified login name. |
|
DropJobsByServer(String) | 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(ScriptingOptions) | (Inherited from SqlSmoObject.) |
|
EnumScriptImplWorker(ScriptingOptions) | (Inherited from SqlSmoObject.) |
|
EnumSubSystems() | Enumerates a list of SQL Server Agent execution subsystems. |
|
Equals(Object) | (Inherited from Object.) |
|
Finalize() | (Inherited from Object.) |
|
FormatSqlVariant(Object) | (Inherited from SqlSmoObject.) |
|
GenerateDataSpaceFileStreamScript(StringBuilder, ScriptingOptions, Boolean) | (Inherited from SqlSmoObject.) |
|
GenerateDataSpaceScript(StringBuilder, ScriptingOptions) | (Inherited from SqlSmoObject.) |
|
GetBindDefaultScript(ScriptingOptions, String, String, Boolean) | (Inherited from SqlSmoObject.) |
|
GetBindRuleScript(ScriptingOptions, String, String, Boolean) | (Inherited from SqlSmoObject.) |
|
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Inherited from SqlSmoObject.) |
|
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Inherited from SqlSmoObject.) |
|
GetDateTimeParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Inherited from SqlSmoObject.) |
|
GetDateTimeParameterAsInt(StringBuilder, ScriptingOptions, String, String, Int32%) | (Inherited from SqlSmoObject.) |
|
GetDBName() | Gets the database name that is associated with the object. (Inherited from SqlSmoObject.) |
|
GetEnumParameter(StringBuilder, ScriptingOptions, String, String, Type, Int32%) | (Inherited from SqlSmoObject.) |
|
GetFragOptionString(FragmentationOption) | (Inherited from SqlSmoObject.) |
|
GetGuidParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Inherited from SqlSmoObject.) |
|
GetHashCode() | (Inherited from Object.) |
|
GetJobByID(Guid) | Returns a job with the specified ID value. |
|
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Inherited from SqlSmoObject.) |
|
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Inherited from SqlSmoObject.) |
|
GetPropValue(String) | (Inherited from SqlSmoObject.) |
|
GetPropValueOptional(String) | (Inherited from SqlSmoObject.) |
|
GetPropValueOptionalAllowNull(String) | (Inherited from SqlSmoObject.) |
|
GetRealValue(Property, Object) | (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(StringBuilder, ScriptingOptions, String, String, Int32%) | (Inherited from SqlSmoObject.) |
|
GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Inherited from SqlSmoObject.) |
|
GetTimeSpanParameterAsInt(StringBuilder, ScriptingOptions, String, String, Int32%) | (Inherited from SqlSmoObject.) |
|
GetType() | (Inherited from Object.) |
|
GetUrnRecursive(StringBuilder) | (Inherited from SqlSmoObject.) |
|
GetUrnRecursive(StringBuilder, UrnIdOption) | (Inherited from SqlSmoObject.) |
|
ImplInitialize(array<String[], array<OrderBy[]) | (Inherited from SqlSmoObject.) |
|
Initialize() | Initializes the object and forces the properties be loaded. (Inherited from SqlSmoObject.) |
|
Initialize(Boolean) | Initializes the object and forces the properties be loaded. (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(Boolean) | (Inherited from SqlSmoObject.) |
|
MemberwiseClone() | (Inherited from 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(String, String) | Enlists SQL Server Agent as a target server with the specified master server in a multiserver administration. |
|
PostAlter() | (Inherited from SqlSmoObject.) |
|
PostCreate() | (Inherited from SqlSmoObject.) |
|
PostDrop() | (Inherited from 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(String, String) | 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. (Inherited from SqlSmoObject.) |
|
RemoveJobByID(Guid) | Removes a job with a specified ID value. |
|
RemoveJobsByLogin(String) | 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(StringCollection, ScriptingOptions) | (Inherited from SqlSmoObject.) |
|
ScriptCreate(StringCollection, ScriptingOptions) | (Inherited from SqlSmoObject.) |
|
ScriptDdl(StringCollection, ScriptingOptions) | (Inherited from SqlSmoObject.) |
|
ScriptDrop(StringCollection, ScriptingOptions) | (Inherited from SqlSmoObject.) |
|
ScriptImpl() | (Inherited from SqlSmoObject.) |
|
ScriptImpl(ScriptingOptions) | (Inherited from SqlSmoObject.) |
|
ScriptImplWorker(ScriptingOptions) | (Inherited from SqlSmoObject.) |
|
SetHostLoginAccount(String, String) | 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(SqlSmoObject) | (Inherited from SqlSmoObject.) |
|
StartMonitor(String, Int32) | 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(String) | 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.) |
|
TouchImpl() | (Inherited from SqlSmoObject.) |
|
UnbindDefaultImpl(Boolean) | (Inherited from SqlSmoObject.) |
|
UnbindRuleImpl(Boolean) | (Inherited from SqlSmoObject.) |
|
Validate(String, array<Object[]) | (Inherited from SmoObjectBase.) |
Top
.gif "Protected field")
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
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 "Protected property") |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Inherited from 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. (Inherited from 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. (Inherited from 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. (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. |
|
ScalarResult | Gets the scalar result for the referenced object. (Inherited from 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. (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
Events
| Name | Description | |
|---|---|---|
.gif "Public event") |
PropertyChanged | (Inherited from SqlSmoObject.) |
|
PropertyMetadataChanged | (Inherited from SqlSmoObject.) |
Top
Explicit Interface Implementations
| Name | Description | |
|---|---|---|
.gif "Explicit interface implemetation") .gif "Private method") |
IAlienObjectDiscover() | (Inherited from SqlSmoObject.) |
|
IAlienObjectGetParent() | (Inherited from SqlSmoObject.) |
|
IAlienObjectGetProperty(String) | (Inherited from SqlSmoObject.) |
|
ISfcPropertyProviderGetPropertySet() | (Inherited from SqlSmoObject.) |
|
IAlienObjectGetUrn() | (Inherited from SqlSmoObject.) |
|
IAlienObjectResolve(String) | (Inherited from SqlSmoObject.) |
|
IAlienObjectSetProperty(Object, Object) | (Inherited from SqlSmoObject.) |
Top