Job.EnumAlerts 方法
Enumerates a list of Agent alerts that cause automated execution of the referenced job.
命名空間： Microsoft.SqlServer.Management.Smo.Agent
組件： Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)
語法
'宣告
Public Function EnumAlerts As DataTable
'用途
Dim instance As Job
Dim returnValue As DataTable
returnValue = instance.EnumAlerts()
public DataTable EnumAlerts()
public:
DataTable^ EnumAlerts()
member EnumAlerts : unit -> DataTable
public function EnumAlerts() : DataTable
傳回值
型別：System.Data.DataTable
A DataTable object value that contains a table of information about the alerts that cause automated execution of the job.
範例
The following code example creates an alert that causes the automated execution of a job, then uses the EnumAlerts method to display its information.
C#
Server srv = new Server("(local)");
Job jb = new Job(srv.JobServer, "jobName");
jb.Create();
jb.ApplyToTargetServer(srv.Name);
Alert al = new Alert(srv.JobServer, "Test Alert");
al.Severity = 17;
al.JobID = jb.JobID;
al.Create()
jb.Refresh()
DataTable alertTable = jb.EnumAlerts()
PowerShell
$jb = new-object Microsoft.SqlServer.Management.Smo.Agent.Job($srv.JobServer, "Test Job23")
$jb.Create()
$jb.ApplyToTargetServer($srv.Name)
$al = new-object Microsoft.SqlServer.Management.Smo.Agent.Alert($srv.JobServer, "Test Alert23")
$al.Severity = 17
$al.JobID = $jb.JobID
$al.Create()
$jb.Refresh()
$alertTable = $jb.EnumAlerts()
請參閱
參考
Microsoft.SqlServer.Management.Smo.Agent 命名空間