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 命名空间