Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Scheduled Agent called but SQL Connect not executed

SA-31273

Summary



A scheduled agent is configured to run an activity to execute several Connect SQL calls.  

After the scheduled time has passed, the state of the database indicates that the Connect SQL calls were never executed.

If the activity is executed manually, the Connect SQL calls execute successfully.


Error Messages



30 Nov 2016 09:34:00,019 [ PegaRULES-Batch-2] ( async.agent.QueueProcessor) DEBUG - No item to process: MyAgentRuelset #1:  MyOrg-MyParentClass-MySubClass.MyAgentActivity


Steps to Reproduce



Execute an standard agent who's agent activity makes one or more Connect SQL calls.


Root Cause



An issue in the custom application code or rules where the agent was created with a mode of "Standard", however no queue items were present.

This resulted in the agent activity not being executed when the agent ran.  In "Standard" mode, at least one queue item is required for the agent activity to execute.


Resolution



Perform the following local-change:

​Adjust the agent to use "Advanced" mode, which will run the activity when the agent runs without the need for any queue items.
Suggest Edit

Published December 19, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us