Metodo JobServer.EnumJobs

Articolo
04/26/2013

Enumerates a list of information about the current job.

Spazio dei nomi Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
Public Function EnumJobs As DataTable
'Utilizzo
Dim instance As JobServer 
Dim returnValue As DataTable 

returnValue = instance.EnumJobs()

public DataTable EnumJobs()

public:
DataTable^ EnumJobs()

member EnumJobs : unit -> DataTable

public function EnumJobs() : DataTable

Valore restituito

Tipo: System.Data.DataTable
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.