Running AQT as an unattended batch job

AQT allows you to run your SQL as an unattended batch job. You may do this for a number of reasons:

• you have a query or other function which you run on a regular basis
• you have a query or other function which you need to run out of hours
• you have a long-running query or other function which you wish to run outside your AQT session

Setting up a new Batch Job

You can set up a new Batch Job :

• from the SQL window with File > Create Batch Job
• from the Data Compare window with File > Create Batch Job
• from the Data Loader window with File > Create Batch Job

For more information on this see Creating a new Batch Job.

Sample Jobs

AQT provides a number of sample batch jobs which you can use to test this feature and to understand it's capabilities.

These sample jobs are located at: C:\Users\<username>\AppData\Roaming\Advanced Query Tool\batch.

You can see / manage then with the Manage Batch Jobs window.

Managing Batch Jobs

AQT provides a window for managing your batch jobs. This allows you to:

• View / edit the batch jobs in your system
• Set up batch job to run on a regular basis using the Windows Task Scheduler
• See a history of the running of your jobs
• Viewing the export files created by your batch jobs

Viewing Export History

In addition to the Manage Batch Jobs window, AQT maintains a history of all data exports. This is a quick way of viewing all export files created by your batch jobs.

The export history can be viewed with the View Export History window.