Proxy

Get-DbaAgentProxy

Chrissy LeMaire (@cl), netnerds.net

Get-DbaAgentProxy View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Retrieves SQL Server Agent proxy accounts and their associated credentials from target instances. Description Retrieves SQL Server Agent proxy accounts which allow job steps to execute under different security contexts than the SQL Agent service account. This function is essential for security auditing, compliance reporting, and troubleshooting job step execution permissions. Returns detailed information including proxy names, associated credentials, descriptions, and enabled status across multiple SQL Server instances.

New-DbaAgentProxy

Chrissy LeMaire (@cl), netnerds.net

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.

Remove-DbaAgentProxy

Mikey Bronowski (@MikeyBronowski), bronowski.it

Remove-DbaAgentProxy View Source Mikey Bronowski (@MikeyBronowski), bronowski.it Windows, Linux, macOS 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.