Export (0) Print
Expand All

Job Methods

(see also Protected Methods )
  Name Description
ms219035.pubmethod(en-US,SQL.90).gif AddSharedSchedule
Adds a shared schedule to the Microsoft SQL Server Agent job.
ms219035.pubmethod(en-US,SQL.90).gif Alter
Updates any Job object property changes on an instance of Microsoft SQL Server.
ms219035.pubmethod(en-US,SQL.90).gif ApplyToTargetServer
Adds a server to the list of target servers maintained for the referenced Microsoft SQL Server Agent job.
ms219035.pubmethod(en-US,SQL.90).gif ApplyToTargetServerGroup
Adds one or more servers to the list of target servers maintained for the referenced Microsoft SQL Server Agent job.
ms219035.pubmethod(en-US,SQL.90).gif Create
Creates a job on the instance of Microsoft SQL Server as defined by the Job object.
ms219035.pubmethod(en-US,SQL.90).gif DeleteJobStepLogs Overloaded.  
ms219035.pubmethod(en-US,SQL.90).gif Drop Overloaded.
Removes an existing job.
ms219035.pubmethod(en-US,SQL.90).gif EnumAlerts
Enumerates a list of Agent alerts that cause automated execution of the referenced job.
ms219035.pubmethod(en-US,SQL.90).gif EnumHistory Overloaded.
Enumerates a list of execution history items associated with the referenced job.
ms219035.pubmethod(en-US,SQL.90).gif EnumJobStepLogs Overloaded.
Enumerates a list of job step log files.
ms219035.pubmethod(en-US,SQL.90).gif EnumJobStepsByID
Returns an array of JobStep objects that belong to the referenced job and that are ordered by ID value.
ms219035.pubmethod(en-US,SQL.90).gif EnumTargetServers
Enumerates a list of execution target servers that have been assigned to the referenced job.
ms219035.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms219035.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms219035.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms219035.pubmethod(en-US,SQL.90).gif Initialize  Overloaded.
Initializes the object and forces the properties be loaded.
(inherited from SqlSmoObject )
ms219035.pubmethod(en-US,SQL.90).gif Invoke
Runs the job.
ms219035.pubmethod(en-US,SQL.90).gif PurgeHistory
Removes system records maintaining execution history for the referenced job.
ms219035.pubmethod(en-US,SQL.90).gif ms219035.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms219035.pubmethod(en-US,SQL.90).gif Refresh 
Refreshes the object and retrieves properties when the object is next accessed.
(inherited from SqlSmoObject )
ms219035.pubmethod(en-US,SQL.90).gif RemoveAllJobSchedules Overloaded.
Removes all shared and unshared schedules from the job.
ms219035.pubmethod(en-US,SQL.90).gif RemoveAllJobSteps
Removes all the job steps associated with the job.
ms219035.pubmethod(en-US,SQL.90).gif RemoveFromTargetServer
Removes an execution target server from the list of target servers maintained for a job.
ms219035.pubmethod(en-US,SQL.90).gif RemoveFromTargetServerGroup
Removes a group of execution target servers from the list of target servers maintained for a job.
ms219035.pubmethod(en-US,SQL.90).gif RemoveSharedSchedule
Removes a shared schedule.
ms219035.pubmethod(en-US,SQL.90).gif Rename
Renames the job.
ms219035.pubmethod(en-US,SQL.90).gif Script Overloaded.
Generates a Transact-SQL script that can be used to re-create the Microsoft SQL Server Agent job.
ms219035.pubmethod(en-US,SQL.90).gif Start Overloaded.
Runs the referenced job.
ms219035.pubmethod(en-US,SQL.90).gif Stop
Stops executing the referenced job.
ms219035.pubmethod(en-US,SQL.90).gif ToString 
Returns a String that represents the referenced object.
(inherited from SqlSmoObject )

  Name Description
ms219035.protmethod(en-US,SQL.90).gif AlterImpl  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif AlterImplFinish  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif AlterImplInit  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif AlterImplWorker  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif BindDefaultImpl  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif BindRuleImpl  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif CheckCollation  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif CheckObjectState  Overloaded.
Validates the state of the referenced object.
(inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif CheckObjectStateImpl  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif CheckVersion80 
Checks the validity of the object on Microsoft SQL Server 2000.
(inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif CheckVersion80SP3 
Checks the validity of the object on Microsoft SQL Server 2000 SP3.
(inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif CheckVersion90 
Check the validity of the object on Microsoft SQL Server 2005.
(inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif CheckVersionBelow90  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif CleanObject  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif CreateImpl  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif CreateImplFinish  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif CreateImplInit  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif DropImpl  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif DropImplWorker  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms219035.protmethod(en-US,SQL.90).gif FormatSqlVariant  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif GenerateDataSpaceScript  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif GetBindDefaultScript  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif GetBindRuleScript  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif GetBoolParameter  Overloaded. (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif GetDateTimeParameter  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif GetDateTimeParameterAsInt  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif GetDBName 
Gets the database name that is associated with the object.
(inherited from AgentObjectBase )
ms219035.protmethod(en-US,SQL.90).gif GetEnumParameter  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif GetFragOptionString  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif GetGuidParameter  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif GetParameter  Overloaded. (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif GetPropValue  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif GetPropValueOptional  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif GetPropValueOptionalAllowNull  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif GetRealValue  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif GetScriptingOptionsForCreate  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif GetServerName 
Gets the name of the instance of Microsoft SQL Server with which the object is associated.
(inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif GetSqlServerVersionName 
Gets the version name of the instance of Microsoft SQL Server with which the object is associated.
(inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif GetStringParameter  Overloaded. (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif GetTimeSpanParameterAsInt  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif GetUrnRecursive  Overloaded. (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif ImplInitialize  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif ms219035.static(en-US,SQL.90).gif IsCollectionDirty  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif IsObjectDirty 
Verifies whether the object properties have been modified and the changes have not yet been persisted on the instance of Microsoft SQL Server.
(inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif IsObjectInitialized 
Verifies whether the object has been initialized.
(inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif IsObjectInSpace 
Verifies whether the object is isolated or connected to the instance of Microsoft SQL Server.
(inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif IsVersion80SP3  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif MarkDropped  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif MarkForDropImpl  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )
ms219035.protmethod(en-US,SQL.90).gif PostAlter  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif PostCreate  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif PostDrop  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif RenameImpl  (inherited from NamedSmoObject )
ms219035.protmethod(en-US,SQL.90).gif RenameImplWorker  (inherited from NamedSmoObject )
ms219035.protmethod(en-US,SQL.90).gif ScriptAlter  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif ScriptChangeOwner  (inherited from NamedSmoObject )
ms219035.protmethod(en-US,SQL.90).gif ScriptCreate  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif ScriptDdl  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif ScriptDrop  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif ScriptImpl  Overloaded. (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif ScriptImplWorker  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif ScriptRename  (inherited from NamedSmoObject )
ms219035.protmethod(en-US,SQL.90).gif SetParentImpl  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif ms219035.static(en-US,SQL.90).gif Trace  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif UnbindDefaultImpl  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif UnbindRuleImpl  (inherited from SqlSmoObject )
ms219035.protmethod(en-US,SQL.90).gif ms219035.static(en-US,SQL.90).gif UpdateCollectionState2  (inherited from SqlSmoObject )

Community Additions

ADD
Show:
© 2014 Microsoft