Install-DbaAgentAdminAlert View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Creates standard SQL Server Agent alerts for critical system errors and disk I/O failures
Description Creates a predefined set of SQL Server Agent alerts that monitor for critical system errors (severity levels 17-25) and disk I/O corruption errors (messages 823-825). These alerts catch serious issues like hardware failures, database corruption, insufficient resources, and fatal system errors that require immediate DBA attention.
New-DbaAgentAlert View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Creates SQL Server Agent alerts for automated monitoring and notification of errors, performance conditions, or system events
Description Creates new SQL Server Agent alerts that monitor for specific error severities, message IDs, performance conditions, or WMI events. Alerts can automatically notify operators via email, pager, or net send when triggered, and optionally execute jobs in response to the monitored condition.
New-DbaAgentAlertCategory View Source Patrick Flynn (@sqllensman) Windows, Linux, macOS Synopsis Creates new SQL Agent alert categories for organizing and managing database alerts.
Description Creates custom alert categories in SQL Server Agent to help organize and group related alerts for better management and monitoring.
Alert categories allow DBAs to logically group alerts by function, severity, or responsibility, making it easier to assign different categories to different teams or escalation procedures.
New-DbaAgentJob View Source Sander Stad (@sqlstad), sqlstad.nl Windows, Linux, macOS Synopsis Creates SQL Server Agent jobs with notification settings and schedule assignments
Description Creates SQL Server Agent jobs with full configuration options including owner assignment, job categories, and comprehensive notification settings.
You can configure email, event log, pager, and netsend notifications with specific operators and trigger conditions (success, failure, completion).
The function also supports attaching existing schedules during job creation and can automatically create missing job categories when using -Force.
New-DbaAgentJobCategory View Source Sander Stad (@sqlstad), sqlstad.nl Windows, Linux, macOS Synopsis Creates new SQL Server Agent job categories for organizing and managing jobs.
Description Creates custom job categories in SQL Server Agent to help organize and classify jobs by function, department, or priority level. Job categories provide a way to group related jobs together for easier management and reporting, replacing the need to manually create categories through SQL Server Management Studio.
New-DbaAgentJobStep View Source Sander Stad (@sqlstad), sqlstad.nl Windows, Linux, macOS Synopsis Creates a new step within an existing SQL Server Agent job with configurable execution options and flow control
Description Creates individual job steps within SQL Server Agent jobs, allowing you to build complex automation workflows without manually configuring each step through SSMS. Each step can execute different types of commands (T-SQL, PowerShell, SSIS packages, OS commands) and includes retry logic, success/failure branching, and output capture.
New-DbaAgentOperator View Source Tracy Boggiano (@TracyBoggiano), databasesuperhero.com Windows, Linux, macOS Synopsis Creates a new SQL Server Agent operator with notification settings for alerts and job failures.
Description Creates SQL Server Agent operators who receive notifications when alerts fire or jobs fail. Operators are contacts that SQL Server Agent can notify via email, pager, or net send when specific events occur. You can configure pager schedules with different time windows for weekdays, weekends, and specific days to control when pager notifications are sent.
New-DbaAgentProxy View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Creates SQL Server Agent proxy accounts to enable job steps to run under different security contexts
Description Creates SQL Server Agent proxy accounts that allow job steps to execute under different security contexts than the SQL Agent service account. Proxy accounts use existing SQL Server credentials and can be assigned to specific subsystems like CmdExec, PowerShell, SSIS, or Analysis Services.
New-DbaAgentSchedule View Source Sander Stad (@sqlstad), sqlstad.nl Windows, Linux, macOS Synopsis Creates a new SQL Server Agent schedule for automated job execution
Description Creates a new schedule in the msdb database that defines when SQL Server Agent jobs should execute. Schedules can be created as standalone objects or immediately attached to existing jobs, allowing you to standardize timing across multiple jobs without recreating the same schedule repeatedly. This replaces the need to manually create schedules through SQL Server Management Studio or T-SQL, while providing comprehensive validation of schedule parameters and frequency options.
Remove-DbaAgentAlert View Source Mikey Bronowski (@MikeyBronowski), bronowski.it Windows, Linux, macOS Synopsis Removes SQL Server Agent alerts from specified instances.
Description Deletes SQL Server Agent alerts that monitor for specific errors, performance conditions, or system events.
Useful for cleaning up obsolete alerts, removing test configurations, or managing alert policies across multiple instances.
Can remove specific alerts by name, exclude certain alerts, or work with piped input from Get-DbaAgentAlert for selective removal.
dbatools