JobServer.EnumJobs Method ()
Enumerates a list of information about the current job.
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntax
'Deklaracja
Public Function EnumJobs As DataTable
public DataTable EnumJobs ()
public:
DataTable^ EnumJobs ()
public DataTable EnumJobs ()
public function EnumJobs () : DataTable
Return Value
A DataTable object value that contains a table of information about SQL Server Agent jobs. The table describes the different columns of the returned DataTable.
Column |
Data type |
Description |
Urn |
String |
A URN value that uniquely identifies the job. |
Name |
String |
The name of the job. |
JobID |
Guid |
A unique system-generated ID value. |
DateCreated |
DateTime |
The date and time when the job was created. |
DateLastModified |
DateTime |
The date and time when the job was last modified. |
Description |
String |
The textual description of the job. |
EmailLevel |
Int32 |
The numeric value that specifies the required way in which the job completes for an e-mail to be sent after execution that is listed in the CompletionAction enumeration. |
IsEnabled |
Boolean |
The Boolean value that specifies whether the job is enabled. If True, the job is enabled. If False, the job is not enabled. |
EventLogLevel |
Int32 |
The numeric value that specifies the required way in which the job completes for an event to be logged after execution that is listed in the CompletionAction enumeration. |
NetSendLevel |
Int32 |
The numeric value that specifies the required way in which the job completes for a net send network message to be sent after execution that is listed in the CompletionAction enumeration. |
OriginatingServer |
String |
The name of the instance of SQL Server that is the master server in a multiserver administration scenario. |
OwnerLoginName |
String |
The name of the login that owns the job. |
PageLevel |
Int32 |
The numeric value that specifies the required way in which the job completes for a pager message to be sent after execution that is listed in the CompletionAction enumeration. |
StartStepID |
Int32 |
The ID value of the job step that is first in the sequence of job steps that belong to the job. |
VersionNumber |
Int32 |
The version number of the job. |
CategoryID |
Int32 |
The job category ID number. |
Thread Safety
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.