Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Clearing ETL execution queue

Clearing ETL execution queue 8 years 3 months ago #2048

  • Barton
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 6
  • Thank you received: 0
Just moved AETL to the new server
Directory structure is slightly different
Now I have enormous amount of data transformation packages waited to be executed and all of them failing because of wrong directory structure
How do I remove all/terminate jobs that are queued in Advanced ETL Processor?

Thanks.
Barton

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

Re: Clearing ETL execution queue 8 years 3 months ago #2049

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7540
  • Karma: 33
  • Thank you received: 412
Close Advanced ETl processor

Than run following sql against repository

delete from QUEUE_ACTIONS

delete from QUEUE

You may also delete all ETL log files as well

Peter
Mike

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

  • Page:
  • 1

We have 202 guests and 2 members online