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

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

  Name Description
ms219116.protproperty(en-US,SQL.90).gif ExecuteForScalar 
Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option.
(inherited from SqlSmoObject )
ms219116.protproperty(en-US,SQL.90).gif ObjectInSpace 
Gets the Boolean property value that specifies whether the object exists in isolation or whether it is connected to the instance of Microsoft SQL Server directly or indirectly.
(inherited from SqlSmoObject )
ms219116.protproperty(en-US,SQL.90).gif PresetProperties 
Gets or sets the preset properties of the referenced object.
(inherited from SqlSmoObject )
ms219116.protproperty(en-US,SQL.90).gif ScalarResult 
Gets the scalar result for the referenced object.
(inherited from SqlSmoObject )

Community Additions

ADD
Show:
© 2015 Microsoft