Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Enumerates a list of Agent alerts that cause automated execution of the referenced job.
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Function EnumAlerts As DataTable
'Usage
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
Return Value
Type: System.Data.DataTable
A DataTable object value that contains a table of information about the alerts that cause automated execution of the job.
Examples
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()
See Also
Reference
Microsoft.SqlServer.Management.Smo.Agent Namespace
Other Resources
Automated Administration Tasks (SQL Server Agent)
Scheduling Automatic Administrative Tasks in SQL Server Agent