Export (0) Print
Expand All

Job Methods

The Job type exposes the following members.

  Name Description
Public method AddSharedSchedule Adds a shared schedule to the Microsoft SQL Server Agent job.
Public method Alter Updates any Job object property changes on an instance of Microsoft SQL Server. 
Public method ApplyToTargetServer Adds a server to the list of target servers maintained for the referenced Microsoft SQL Server Agent job.
Public method ApplyToTargetServerGroup Adds one or more servers to the list of target servers maintained for the referenced Microsoft SQL Server Agent job.
Public method Create Creates a job on the instance of Microsoft SQL Server as defined by the Job object.
Public method DeleteJobStepLogs(DateTime) Deletes job step log files that are older than the specified date.
Public method DeleteJobStepLogs(Int32) Deletes job step log files that are larger that the specified log ID number.
Public method Discover Discovers a list of type Object. (Inherited from SqlSmoObject.)
Public method Drop() Removes an existing job.
Public method Drop(Boolean) Removes an existing job.
Public method EnumAlerts Enumerates a list of Agent alerts that cause automated execution of the referenced job.
Public method EnumHistory() Enumerates a list of execution history associated with the referenced job.
Public method EnumHistory(JobHistoryFilter) Enumerates a list of execution history associated with the referenced job.
Public method EnumJobStepLogs() Enumerates a list of job step log files for the referenced job.
Public method EnumJobStepLogs(Int32) Enumerates a list of job step log files for the job step with the specified ID value.
Public method EnumJobStepLogs(String) Enumerates a list of job step log files for the job step with the specified name.
Public method EnumJobStepsByID Returns an array of JobStep objects that belong to the referenced job and that are ordered by ID value.
Public method EnumTargetServers Enumerates a list of execution target servers that have been assigned to the referenced job.
Public method Equals (Inherited from Object.)
Protected method FormatSqlVariant Formats an object as SqlVariant type. (Inherited from SqlSmoObject.)
Protected method GetContextDB Gets the context database that is associated with this object. (Inherited from SqlSmoObject.)
Protected method GetDBName Gets the database name that is associated with the object. (Inherited from AgentObjectBase.)
Public method GetHashCode (Inherited from Object.)
Protected method GetPropValue Gets a property value of the SqlSmoObject object. (Inherited from SqlSmoObject.)
Protected method GetPropValueOptional Gets a property value of the SqlSmoObject object. (Inherited from SqlSmoObject.)
Protected method GetPropValueOptionalAllowNull Gets a property value of the SqlSmoObject object. (Inherited from SqlSmoObject.)
Protected method GetServerObject Gets the server of the SqlSmoObject object. (Inherited from SqlSmoObject.)
Public method GetType (Inherited from Object.)
Public method Initialize() Initializes the object and forces the properties be loaded. (Inherited from SqlSmoObject.)
Public method Initialize(Boolean) Initializes the object and forces the properties be loaded. (Inherited from SqlSmoObject.)
Public method Invoke Runs the job.
Protected method IsObjectInitialized Verifies whether the object has been initialized. (Inherited from SqlSmoObject.)
Protected method IsObjectInSpace Verifies whether the object is isolated or connected to the instance of SQL Server. (Inherited from SqlSmoObject.)
Public method PurgeHistory Removes system records maintaining execution history for the referenced job.
Public method Refresh Refreshes the object and retrieves properties when the object is next accessed. (Inherited from SqlSmoObject.)
Public method RemoveAllJobSchedules() Removes all shared and unshared schedules from the job.
Public method RemoveAllJobSchedules(Boolean) Removes all unused schedules from the job.
Public method RemoveAllJobSteps Removes all the job steps associated with the job.
Public method RemoveFromTargetServer Removes an execution target server from the list of target servers maintained for a job.
Public method RemoveFromTargetServerGroup Removes a group of execution target servers from the list of target servers maintained for a job.
Public method RemoveSharedSchedule(Int32) Removes the specified shared schedule from the job.
Public method RemoveSharedSchedule(Int32, Boolean) Removes the specified shared schedule from the job and keeps unused schedules.
Public method Rename Renames the job.
Public method Script() Generates a Transact-SQL script that can be used to re-create the Microsoft SQL Server Agent job.
Public method Script(ScriptingOptions) Generates a Transact-SQL script that can be used to re-create the Microsoft SQL Server Agent job as specified by the scripting options.
Protected method SetParentImpl Sets the parent of the SqlSmoObject to the newParent parameter. (Inherited from SqlSmoObject.)
Public method Start() Runs the referenced job.
Public method Start(String) Runs the referenced job starting at the specified job step.
Public method Stop Stops executing the referenced job.
Public method ToString Returns a String that represents the referenced object. (Inherited from SqlSmoObject.)
Public method Validate Validates the state of an object. (Inherited from SmoObjectBase.)
Top

  Name Description
Explicit interface implemetation Private method IAlienObject.Discover Discovers any dependencies. Do not reference this member directly in your code. It supports the SQL Server infrastructure. (Inherited from SqlSmoObject.)
Explicit interface implemetation Private method IAlienObject.GetDomainRoot Returns the root of the domain. (Inherited from SqlSmoObject.)
Explicit interface implemetation Private method IAlienObject.GetParent Gets the parent of this object. Do not reference this member directly in your code. It supports the SQL Server infrastructure. (Inherited from SqlSmoObject.)
Explicit interface implemetation Private method IAlienObject.GetPropertyType Gets the type of the specified property. (Inherited from SqlSmoObject.)
Explicit interface implemetation Private method IAlienObject.GetPropertyValue Gets the value of the specified property. (Inherited from SqlSmoObject.)
Explicit interface implemetation Private method IAlienObject.GetUrn Gets the Unified Resource Name (URN) of the object. Do not reference this member directly in your code. It supports the SQL Server infrastructure. (Inherited from SqlSmoObject.)
Explicit interface implemetation Private method IAlienObject.Resolve Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. (Inherited from SqlSmoObject.)
Explicit interface implemetation Private method IAlienObject.SetObjectState Sets the object state to the specified SfcObjectState value. (Inherited from SqlSmoObject.)
Explicit interface implemetation Private method IAlienObject.SetPropertyValue Sets the property value. (Inherited from SqlSmoObject.)
Explicit interface implemetation Private method ISfcPropertyProvider.GetPropertySet Gets the interface reference to the set of properties of this object. (Inherited from SqlSmoObject.)
Top

Community Additions

ADD
Show:
© 2014 Microsoft