Copy-DbaAgentAlert View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Copies SQL Server Agent alerts from source instance to destination instances
Description Transfers SQL Server Agent alerts from a source instance to one or more destination instances, preserving their configurations, notification settings, and job associations. This function handles the complex dependencies between alerts, operators, and jobs automatically, ensuring alerts work properly after migration.
Essential for server migrations, disaster recovery preparation, and standardizing monitoring across multiple SQL Server environments.
Copy-DbaAgentJob View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Migrates SQL Server Agent jobs between instances with dependency validation
Description Copies SQL Server Agent jobs from one instance to another while automatically validating all dependencies including databases, logins, proxy accounts, and operators. This eliminates the manual process of checking prerequisites before moving jobs during migrations, disaster recovery, or environment promotions.
The function intelligently skips jobs associated with maintenance plans and provides detailed validation messages for any missing dependencies.
Copy-DbaAgentJobCategory View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Copies custom SQL Agent categories for jobs, alerts, and operators between SQL Server instances.
Description Migrates custom SQL Agent categories from a source SQL Server to one or more destination servers, so you don’t have to manually recreate organizational structures during server migrations or environment setups.
This function copies only user-defined categories (ID >= 100), preserving built-in system categories on the destination.
Copy-DbaAgentOperator View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Copies SQL Server Agent operators between instances for migration and standardization.
Description Copies SQL Server Agent operators from a source instance to one or more destination instances, preserving all operator properties including email addresses, pager numbers, and notification schedules. This is essential during server migrations, environment standardization, or when setting up identical alerting configurations across multiple instances.
All operators are copied by default, but you can target specific operators or exclude certain ones.
Copy-DbaAgentProxy View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Copies SQL Server Agent proxy accounts from one instance to another.
Description Migrates SQL Server Agent proxy accounts between instances, enabling job steps to run under different security contexts than the SQL Agent service account. By default, all proxy accounts are copied, but you can specify individual accounts to migrate or exclude specific ones. The function requires that associated credentials already exist on the destination server before copying proxy accounts.
Copy-DbaAgentSchedule View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Migrates SQL Agent shared job schedules between SQL Server instances for job schedule standardization.
Description Copies shared job schedules (not job-specific schedules) from the source SQL Server Agent to one or more destination instances using T-SQL scripting. This is essential when standardizing job schedules across multiple servers or migrating Agent configurations to new instances. Existing schedules are skipped by default unless -Force is specified, and schedules with associated jobs cannot be overwritten even with Force to prevent breaking existing job assignments.
Stephen Bennett, sqlnotesfromtheunderground.wordpress.com
Find-DbaAgentJob View Source Stephen Bennett, sqlnotesfromtheunderground.wordpress.com Windows, Linux, macOS Synopsis Searches and filters SQL Agent jobs across SQL Server instances using multiple criteria.
Description Searches SQL Agent jobs across one or more SQL Server instances using various filter criteria including job name, step name, execution status, schedule status, and notification settings. Helps DBAs identify problematic jobs that have failed, haven’t run recently, are disabled, lack schedules, or missing email notifications.
Get-DbaAgentAlert View Source Klaas Vandenberghe (@PowerDBAKlaas) Windows, Linux, macOS Synopsis Retrieves SQL Server Agent alert configurations from one or more instances
Description Retrieves alert configurations from SQL Server Agent, including alert names, types, severity levels, message IDs, and notification settings. Use this to audit alert configurations across multiple servers, troubleshoot missing or misconfigured alerts, or gather information for compliance reporting. The function returns detailed alert properties like enabled status, last occurrence dates, and response delays, making it essential for monitoring your alerting infrastructure and ensuring critical system events are properly configured for notification.
Get-DbaAgentAlertCategory View Source Patrick Flynn (@sqllensman) Windows, Linux, macOS Synopsis Retrieves SQL Server Agent alert categories and their associated alert counts
Description Retrieves all SQL Server Agent alert categories from the target instances, showing how alerts are organized and grouped. Categories help DBAs manage alerts logically by grouping related notifications (such as severity-based alerts, database maintenance alerts, or custom business alerts). The function also returns a count of how many alerts are currently assigned to each category, making it useful for understanding your alerting structure and identifying unused or heavily-used categories.
Get-DbaAgentJob View Source Garry Bargsley (@gbargsley), blog.garrybargsley.com Windows, Linux, macOS Synopsis Retrieves SQL Server Agent job details and execution status from one or more instances.
Description Retrieves detailed information about SQL Server Agent jobs including their configuration, status, schedules, and execution history. This function connects to SQL instances and queries the msdb database to return job properties like owner, category, last run outcome, and current execution status. Use this to monitor job health across your environment, audit job configurations before deployments, or identify jobs associated with specific databases for maintenance planning.
dbatools