JobServer.EnumJobs Method ()
Enumerates a list of information about the current job.
命名空间: Microsoft.SqlServer.Management.Smo.Agent
程序集: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
语法
声明
Public Function EnumJobs As DataTable
public DataTable EnumJobs ()
public:
DataTable^ EnumJobs ()
public DataTable EnumJobs ()
public function EnumJobs () : DataTable
返回值
A DataTable object value that contains a table of information about Microsoft 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. |
Category |
String |
The name of the category to which the job is assigned. |
CurrentRunRetryAttempt |
Int32 |
The number of attempts, including the current attempt, that the job has been run and retried. |
CurrentRunStatus |
Int32 |
The numeric value that represents a specific execution status that is listed in the JobExecutionStatus enumeration. |
CurrentRunStep |
Int32 |
The numeric value that identifies the currently running job step. |
DateCreated |
DateTime |
The date and time when the job was created. |
DateLastModified |
DateTime |
The date and time when the job was last modified. |
DeleteLevel |
Int32 |
The numeric value that specifies the required way in which the job completes for the job to be deleted after execution that is listed in the CompletionAction enumeration. |
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. |
HasSchedule |
Boolean |
The Boolean value that specifies whether the job has at least one schedule assigned to it. If True, the job has at least one schedule. If False, the job has no schedules. |
HasServer |
Boolean |
The Boolean value that specifies whether the job is scheduled to run on a target server in a multiserver administration scenario. If True, the job has at least one target server. If False, the job does not have a target server. |
HasStep |
Boolean |
The Boolean value that specifies whether the job has at least one job step assigned to it. If True, the job has at least one job step. If False, the job does not have a job step. |
LastRunDate |
DateTime |
The date and time when the job was last executed. |
LastRunOutcome |
Int32 |
The numeric value that specifies the way in which the job completed the last time it was executed 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. |
NextRunDate |
DateTime |
The date and time when the job is next scheduled to run. |
NextRunScheduleID |
Int32 |
The numeric ID value that uniquely identifies the schedule that is used the next time the job runs. |
OperatorToEmail |
String |
The name of the operator to e-mail when the job requires that e-mail is sent on completion. |
OperatorToNetSend |
String |
The name of the operator to net send when the job requires that e-mail is sent on completion. |
OperatorToPage |
String |
The name of the operator to page when the job requires that e-mail is sent on completion. |
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 logon 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. |
JobType |
Int32 |
The numeric value that specifies the type of job that is listed in the JobType enumeration. |
VersionNumber |
Int32 |
The version number of the job. |
备注
仅 Microsoft .NET Framework 的 2.0 版本支持此命名空间、类或成员。
示例
How to: Create a Job with Steps and a Schedule in Visual Basic .NET
线程安全
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.
平台
开发平台
有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。
目标平台
有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。
请参阅
参考
JobServer Class
JobServer Members
Microsoft.SqlServer.Management.Smo.Agent Namespace
其他资源
自动执行管理任务（SQL Server 代理）
Scheduling Automatic Administrative Tasks in SQL Server Agent
sp_help_job (Transact-SQL)