Agent

More
9 years 10 months ago #8770 by mdspeirs
Agent was created by mdspeirs
AETLP E 5.7.6.5
Windows 7 Pro 64 bit SP1
Repository MS SQL

AETPL E has been reinstalled to update it several times.

I'm expecting the agent to be running automatically when the computer is running and to execute tasks, but there's some sort of disconnect.

Tasks scheduled to run via agent don't run.

Attempts to install, register or unregister agent get PK violation.

Clicking "Check Status", sometimes nothing happens, sometimes the grid get populated

No aetlagents process were showing in task mananger, but after trying various buttons under Execution Agent Management 2 instances are running.
However Execution Agent Management says Service is not running.

Please Log in or Create an account to join the conversation.

More
9 years 10 months ago #8771 by admin
Replied by admin on topic Agent
Attempts to install, register or unregister agent get PK violation.

Can you post a screenshot please

Mike

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
9 years 10 months ago #8780 by mdspeirs
Replied by mdspeirs on topic Agent
some screen shots attached
Attachments:

Please Log in or Create an account to join the conversation.

More
9 years 10 months ago #8781 by admin
Replied by admin on topic Agent
Please run this script and let us know the outcome

DELETE from AGENT_STATUS
DELETE from AGENT_ACTIVITY

Mike

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
9 years 10 months ago #8782 by admin
Replied by admin on topic Agent
By looking at the screenshots I can see that the agent is already running,
what makes you think that you have to register it again?
Am I missing something?

Mike

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
9 years 10 months ago #8783 by mdspeirs
Replied by mdspeirs on topic Agent
Haven't tried the script yet, but here's another screen shot.
Attachments:

Please Log in or Create an account to join the conversation.