How do we clear any agent procedures that are currently pending to run on all VSA agents?
ClearPendingProcedures MD5 Hash: 4d828a98800645e47ec0d1860f153a86
Place the file on your SQL server Desktop or other similarly accessible location on the server
Double click or "open" the file, this should launch SQL Server Management Studio click "connect" to authenticate.
Click "Connect" and Execute the script:
You should see the following message:
Open a "New Query" window:
And run the following command
NOTE: This may take a long time to execute, in some cases hours.
Run the following Query:
delete from scriptAssignment
where execscripttime < getdate()
and eventinstanceid = 0
Run the following Query
update scriptAssignment set inProc = 0 where inProc = 1