HomeForum
Welcome, Guest
ETL-Forum
Forum
Advanced ETL Processor

Clearing ETL execution queue
(1 viewing) (1) Guest
Reply Topic
New Topic
  • Page:
  • 1

TOPIC: Clearing ETL execution queue

Clearing ETL execution queue 1 year, 2 months ago #2048

  • Barton
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 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
Reply Quote

Re: Clearing ETL execution queue 1 year, 2 months ago #2049

  • admin
  • NOW ONLINE
  • Moderator
  • Posts: 2182
  • Karma: 12
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
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
ETL-Forum
Forum
Advanced ETL Processor
Powered by Kunena
Time to create page: 0.16 seconds

Testimonials

Currently we are using Visual Importer Ent to import our client’s customer RMA data into our SQL server for further processing and export same data to their ftp server.

We Process 3000 files daily, 24h x 365d

C Gandhi
Nesa-Canada

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC

Databases we work with

Submit to Delicious Submit to Digg Submit to Facebook Submit to Google Bookmarks Submit to Stumbleupon Submit to Technorati Submit to Twitter Submit to LinkedIn
Go to top