dbatools is a free PowerShell module with over 180 SQL Server administration, best practice and migration commands included.


Get-DbaAgentAlert

Returns all SQL Agent alerts on a SQL Server Agent.

Screenshots

Examples

Returns all SQL Agent alerts on serverA and serverB\instanceB

Get-DbaAgentAlert -SqlServer ServerA,ServerB\instanceB

Returns all SQL Agent alerts on serverA and serverB\instanceB

‘serverA’,’serverB\instanceB’ | Get-DbaAgentAlert

Author

This command was created by Klaas Vandenberghe. You can find Klaas on Twitter and his blog.

Get-Help

From PowerShell, execute Get-Help Get-DbaAgentAlert -Detailed for more information on this function.

Source Code

Want to see the source code? View Get-DbaAgentAlert.ps1 on GitHub
 

Related commands