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 | |
---|---|---|
![]() |
AddDatabaseContext(StringCollection) | (Inherited from SqlSmoObject.) |
![]() |
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
Properties
Name | Description | |
---|---|---|
![]() |
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. |
![]() |
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 | |
---|---|---|
![]() |
PropertyChanged | (Inherited from SqlSmoObject.) |
![]() |
PropertyMetadataChanged | (Inherited from SqlSmoObject.) |
Top
Explicit Interface Implementations
Name | Description | |
---|---|---|
![]() ![]() |
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