I need to execute/launch a PowerShell script after my maintenance plan did some work on my database.
Is this possible?
I need to execute/launch a PowerShell script after my maintenance plan did some work on my database.
Is this possible?
Copyright © 2021 Jogjafile Inc.
You can run your
PowerShell
script withinSQL Server 2008/2008r2/2012 Agent
. In SQL Server Management Studio create a SQL job and select aPowerShell job step
specifying the full path to your PowerShell script. Then add the job at the end of your maintenance plan as 'Execute SQL Server Agent Job Task
'