Modules
Sign in
Get Help

Clear Pending Procedures in the VSA

Question

How do we clear any agent procedures that are currently pending to run on all VSA agents?

Answer

Step 1 

Download the following procedure by clicking here ClearPendingProcedures.SQL

ClearPendingProcedures MD5 Hash: 4d828a98800645e47ec0d1860f153a86

Step 2

Place the file on your SQL server Desktop or other similarly accessible location on the server

Desktop.png

Step 3

Double click or "open" the file, this should launch SQL Server Management Studio click "connect" to authenticate.

mceclip2.png

 

Step 4

Click "Connect" and Execute the script:

mceclip3.png

You should see the following message: 

mceclip4.png

Step 5

Open a "New Query" window: 

mceclip5.png

 

And run the following command

exec [dbo].[clearPendingProcedures]

 

mceclip6.png

 

NOTE: This may take a long time to execute, in some cases hours. 

Step 6

Run the following Query:

delete from scriptAssignment
where execscripttime < getdate()
and eventinstanceid = 0

Step 7

Run the following Query

update scriptAssignment set inProc = 0 where inProc = 1

 

mceclip0.png

 

 

 

 

 

 

 

 

 

 

 

Attachments

Have more questions?

Contact us

Was this article helpful?
5 out of 5 found this helpful

Provide feedback for the Documentation team!

Browse this section