JagannathR8869 Member since 2016 43 posts
DXC Technology
Posted: November 6, 2017
Last activity: November 8, 2017

Deletion of useless nodes in agent schedule by query in DB

After a server migration, the agent schedule needs to be set up on the new nodes. Since its tedious to do manually, to do this, we usually delete all the agent schedule by executing a delete query on the table pr_data where pxobjclass = 'Data-Agent-Queue'. This has a disadvantage that the new nodes and old nodes both get deleted. Thus when the new agent schedules are again generated from the agent, the configuration in the agent mandates configuration of the new agent schedules.

Since the agent rules are locked by the development teams(they are part of a common jar for multiple applications using common agents), as an admin i have to work only with agent schedules. Thus when there are certain agent schedules which are needed to be switched off by me or on by me after such migrations for an app, i have to revisit every agent and turn them off since most of them are kept on in the common framework of agent.

Is there a better way to handle this scenario as an admin.



System Administration
Moderation Team has archived post
Share this page LinkedIn