Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Job Properties

Job Properties

The Job type exposes the following members.

  NameDescription
Public property Category Gets or sets the category to which the job belongs.
Public property CategoryID Gets the ID value that uniquely identifies the job category.
Public property CategoryType Gets or sets the type of category, with respect to local or multiserver jobs.
Public property CurrentRunRetryAttempt Gets the number of times Microsoft SQL Server Agent has attempted to run the job unsuccessfully.
Public property CurrentRunStatus Gets the current execution status of the job.
Public property CurrentRunStep Gets information about the job step that is currently running.
Public property DateCreated Gets the date and time when the job was created.
Public property DateLastModified Gets the date and time when the job was last modified.
Public property DeleteLevel Gets or sets the completion action that determines whether to delete the job definition when the job finishes execution.
Public property Description Gets or sets the textual description of the job.
Public property EmailLevel Gets or sets the completion action that determines whether to send an e-mail notification to an operator when the job finishes execution.
Public property EventLogLevel Gets or sets the completion action that determines whether to generate an operating system event log entry when the job finishes execution.
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.)
Public property HasSchedule Gets the Boolean property value that specifies whether the job has at least one schedule.
Public property HasServer Gets the Boolean property value that specifies whether the job has a target server assigned for multiple-server operations.
Public property HasStep Gets the Boolean property value that specifies whether the job has at least one job step.
Public property IsEnabled Gets or sets the Boolean property value that specifies whether the job is enabled.
Protected property 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.)
Public property JobID Gets or sets the job ID value.
Public property JobSchedules Gets a collection of JobSchedule objects that represent the schedules assigned to the job.
Public property JobSteps Gets a collection of JobStep objects that represent the job steps defined for the job.
Public property JobType Gets the job type, which specifies whether the job is local or multiserver.
Public property LastRunDate Gets the date and time when the job was last run.
Public property LastRunOutcome Gets the result of the job from the last time it completed execution.
Public property Name (Overrides NamedSmoObject.Name.)
Public property NetSendLevel Gets or sets the completion action that determines whether to net-send a notification to an operator when the job finishes execution.
Public property NextRunDate Gets the date and time when the job is next scheduled to run.
Public property NextRunScheduleID Gets the ID value of the schedule that is responsible for the next execution of the job.
Protected property 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.)
Public property OperatorToEmail Gets or sets the operator that receives notification by e-mail when the job finishes execution.
Public property OperatorToNetSend Gets or sets the operator that receives a net-send notification when the job finishes execution.
Public property OperatorToPage Gets or sets the operator that receives a pager notification when the job finishes execution.
Public property OriginatingServer Gets the name of the server that is acting as the master server in a multiserver job.
Public property OwnerLoginName Gets or sets the owner of the job.
Public property PageLevel Gets or sets the completion action that determines whether to send a pager notification to an operator when the job finishes execution.
Public property Parent Gets or sets the JobServer object that is the parent of the Job object.
Public property Properties Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.)
Protected property ScalarResult Gets the scalar result for the referenced object. (Inherited from SqlSmoObject.)
Public property StartStepID Gets or sets the ID value of the first job step in the sequence to be executed.
Public property State Gets the state of the referenced object. (Inherited from SmoObjectBase.)
Public property Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.)
Public property UserData Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.)
Public property VersionNumber Gets a system-maintained value that is incremented every time the job is modified.
Top

Community Additions

ADD
Show:
© 2015 Microsoft