Compare-DbaAgReplicaAgentJob View Source dbatools team Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Compares SQL Agent Jobs across Availability Group replicas to identify configuration differences.
Description Compares SQL Agent Jobs across all replicas in an Availability Group to identify differences in job configurations. This helps ensure consistency across AG replicas and detect when jobs have been modified on one replica but not others.
Compare-DbaAvailabilityGroup View Source dbatools team Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Compares configuration across Availability Group replicas to identify differences in Jobs, Logins, Credentials, and Operators.
Description Compares multiple object types across all replicas in an Availability Group to identify configuration differences. This comprehensive command checks SQL Agent Jobs, SQL Server Logins, SQL Server Credentials, and SQL Agent Operators to ensure consistency across AG replicas.
Copy-DbaAgentJob View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.
Copy-DbaAgentJobStep View Source the dbatools team + Claude Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Copies job steps from one SQL Server Agent job to another, preserving job history by synchronizing steps without dropping the job itself.
Description Synchronizes SQL Server Agent job steps between instances by copying step definitions from source jobs to destination jobs. Unlike Copy-DbaAgentJob with -Force, this command preserves job execution history because it only drops and recreates individual steps rather than the entire job.
Stephen Bennett, sqlnotesfromtheunderground.wordpress.com
Find-DbaAgentJob View Source Stephen Bennett, sqlnotesfromtheunderground.wordpress.com Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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-DbaAgentJob View Source Garry Bargsley (@gbargsley), blog.garrybargsley.com Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.
Get-DbaAgentJobCategory View Source Sander Stad (@sqlstad), sqlstad.nl Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves SQL Server Agent job categories with usage counts and filtering options
Description Returns SQL Server Agent job categories from one or more instances, showing how many jobs are assigned to each category. Job categories help organize and group related SQL Agent jobs for easier management and reporting.
Get-DbaAgentJobHistory View Source Klaas Vandenberghe (@PowerDbaKlaas) , Simone Bizzotto (@niphold) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves SQL Server Agent job execution history from msdb database for troubleshooting and compliance reporting.
Description Get-DbaAgentJobHistory queries the msdb database to retrieve detailed execution records for SQL Server Agent jobs, helping you troubleshoot failures, monitor performance trends, and generate compliance reports.
Rob Sewell (sqldbawithabeard.com) | Simone Bizzotto (@niphlod)
Get-DbaAgentJobOutputFile View Source Rob Sewell (sqldbawithabeard.com) , Simone Bizzotto (@niphlod) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves output file paths configured for SQL Agent job steps
Description This function returns the file paths where SQL Agent job steps write their output logs. When troubleshooting failed jobs or reviewing execution history, DBAs often need to locate these output files to examine detailed error messages and execution details.
Get-DbaAgentJobStep View Source Klaas Vandenberghe (@PowerDbaKlaas), powerdba.eu Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves detailed SQL Agent job step information including execution status and configuration from SQL Server instances.
Description Collects comprehensive details about SQL Agent job steps across one or more SQL Server instances. Returns information about each step’s subsystem type, last execution date, outcome, and current state, which is essential for monitoring job performance and troubleshooting failed automation tasks.
dbatools