This extension allows executing SQL queries (manually/automatically using cron) and send them to selected email address(es).



** FEATURES ***
1. Supports EVERY MySQL command (SELECT, INSERT, UPDATE, DELETE).
2. Allows preview of SELECT query with a click of a button.
3. Allows execution of any query with a click of a button.
4. Supports definition of next execution date, execution hour, job status (Enabled/Disabled), next execution interval (by days, months or years).





*** SIDEBAR SHORTCUT ***
Extension shortcut under Reports category -> Query Jobs.

*** INSTALLATION ***
Simple Install using built-in ocmod modification installer.

*** CRON EXECUTION ***
To execute queries automatically using cron, you must define one cron job that will browse to following link every HOUR:
<your_store_url>/admin/index.php?route=extension/module/jobs/cron