New-DbaAgentProxy View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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 On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.
Remove-DbaAgentAlert View Source Mikey Bronowski (@MikeyBronowski), bronowski.it Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.
Remove-DbaAgentAlertCategory View Source Patrick Flynn (@sqllensman) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Removes SQL Server Agent alert categories from SQL Server instances.
Description Removes custom alert categories from SQL Server Agent, useful for cleaning up unused organizational structures or standardizing alert management across environments.
Any existing alerts that reference the removed category will automatically be reassigned to the [Uncategorized] category, so you don’t need to manually update alert assignments before removal.
Remove-DbaAgentJob View Source Sander Stad (@sqlstad, sqlstad.nl) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Removes SQL Server Agent jobs from one or more instances with options to preserve history and schedules.
Description Removes SQL Server Agent jobs from the target instances using the sp_delete_job system stored procedure. By default, both job history and unused schedules are deleted along with the job itself.
Remove-DbaAgentJobCategory View Source Sander Stad (@sqlstad, sqlstad.nl) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Removes SQL Server Agent job categories from one or more instances.
Description Removes custom SQL Server Agent job categories that are no longer needed for job organization and management.
This is useful when cleaning up obsolete categories after reorganizing jobs or migrating workloads between environments.
Remove-DbaAgentJobStep View Source Sander Stad (@sqlstad), sqlstad.nl Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Removes specified job steps from SQL Server Agent jobs.
Description Removes individual job steps from SQL Server Agent jobs by step name. This function validates that both the job and step exist before attempting removal, preventing errors when cleaning up outdated or broken job steps.
Remove-DbaAgentOperator View Source Tracy Boggiano (@TracyBoggiano), databasesuperhero.com Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Removes SQL Server Agent operators from one or more instances.
Description Removes SQL Server Agent operators from specified instances, cleaning up notification contacts that are no longer needed.
Operators are notification contacts used by SQL Server Agent to send alerts about job failures, system issues, or other events.
Remove-DbaAgentProxy View Source Mikey Bronowski (@MikeyBronowski), bronowski.it Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Removes SQL Agent agent proxy(s).
Description Removes the SQL Agent proxy(s) that have passed through the pipeline.
If not used with a pipeline, Get-DbaAgentProxy will be executed with the parameters provided
and the returned SQL Agent proxy(s) will be removed.
Syntax Remove-DbaAgentProxy [-SqlInstance <DbaInstanceParameter[]>] [-SqlCredential <PSCredential>] [-Proxy <String[]>] [-ExcludeProxy <String[]>] [-WhatIf] [-Confirm] [<CommonParameters>] Remove-DbaAgentProxy [-SqlInstance <DbaInstanceParameter[]>] [-SqlCredential <PSCredential>] [-Proxy <String[]>] [-ExcludeProxy <String[]>] -InputObject <ProxyAccount[]> [-EnableException] [-WhatIf] [-Confirm] [<CommonParameters>] Examples Example: 1 PS C:\> Remove-DbaAgentProxy -SqlInstance localhost, localhost\namedinstance Removes all SQL Agent proxies on the localhost, localhost\namedinstance instances.
Remove-DbaAgentSchedule View Source Sander Stad (@sqlstad), sqlstad.nl Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Removes SQL Server Agent schedules from one or more instances.
Description Removes SQL Server Agent schedules from the msdb database, handling both unused schedules and those currently assigned to jobs. The function first removes schedule associations from any jobs using the schedule, then drops the schedule itself to prevent orphaned references.
dbatools