Running AQT as an unattended batch job

In This Chapter

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.

Advanced Query Tool

https://www.querytool.com