Southsoftware.com
.:Pricing
Home
Products
Downloads
Support
Contacts
Site Map
.:Advanced Task Scheduler
About product
Download trial
Purchase license
Compare editions
View screenshot
FAQ & Support
Press Kit
.:Articles
Online manual
Blog posts
Videos
More articles...
.:Follow us
Follow us on Facebook Follow us on Twitter Follow us on YouTube
   

Advanced Task Scheduler’s SQLite database

From version 5.0 and later Advanced Task Scheduler uses SQLite database file to store its settings and scheduled tasks.

You can find location and file name of SQLite database file in this topic: Scheduled Tasks location and upgrade compatibility.

For your convenience we have published SQLite Shell, which was built with the same options as Advanced Task Scheduler uses internally. You can download the shell here: sqlite.zip.

This topic covers a few examples of SQLite Shell commands that can be used to tune up Advanced Task Scheduler’s functionality.

Do not forget to exit Advanced Task Scheduler and stop it’s service before modifying database.

Dump history

.open "C:/ProgramData/Advanced Task Scheduler Network/allusers.sqlite"
.load "guidstring.dll"
SELECT datetime(actiontime, 'unixepoch', 'localtime'), errorcode, exitcode, (select name from tasks where tasks.guid=task_guid), actionschedule, actionsource, actionsourceextra, exelog FROM history ORDER BY actiontime DESC;

Clear history

.open "C:/ProgramData/Advanced Task Scheduler Network/allusers.sqlite"
.load "guidstring.dll"
DELETE FROM history;

Dump root groups

.open "C:/ProgramData/Advanced Task Scheduler Network/allusers.sqlite"
.load "guidstring.dll"
SELECT GuidToString(guid), type, name, icon, datetime(last_modified, 'unixepoch', 'localtime') FROM root;

Insert another local tasks group

This may be useful as root groups use their own settings such as log file and user account options.

.open "C:/ProgramData/Advanced Task Scheduler Network/allusers.sqlite"
.load "guidstring.dll"
INSERT INTO root(guid, type, name, icon, last_modified) VALUES (GuidCreate(), 0, 'Another local tasks', '', strftime('%s','now'));

Insert another replicated tasks group

This may be useful as root groups use their own settings such as log file, user account and replication options (Network Edition only).

.open "C:/ProgramData/Advanced Task Scheduler Network/allusers.sqlite"
.load "guidstring.dll"
SELECT GuidToString(GuidCreate());

The new GUID will be displayed. Use the following commands to create new replicated tasks group on the all machines where you want to use the same replicated group. The “XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX” should be replaced with the actual GUID that was returned on the previous step.

.open "C:/ProgramData/Advanced Task Scheduler Network/allusers.sqlite"
.load "guidstring.dll"
INSERT INTO root(guid, type, name, icon, last_modified) VALUES (GuidFromString("XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX"), 1, 'Another replicated tasks', '', strftime('%s','now'));

In these examples “C:/ProgramData/Advanced Task Scheduler Network/allusers.sqlite” should be replaced with your actual file name and path; “guidstring.dll” is an SQLite Extension that is available from the package listed above.

Related Articles
Scheduled Tasks location and upgrade compatibility

Categories: Manual, Troubleshooting

   
About us   Privacy policy   Terms of use   Link to us
Current Version: 5.1.0.702
The following prices are based on a single order:
Basic Edition 32 and 64-bit$ 39.95 USD
Professional Edition 32 and 64-bit$ 59.95 USD
Network Edition 32 and 64-bit$ 149.95 USD
.:Testimonials

I had the pleasure of purchasing Advanced Task Scheduler, an incredibly versatile, advanced windows task scheduler. This program has taken the Windows Task Scheduler to a new level. The customer service is superb. I needed a specific modification to the program, and they accommodated it by sending me a patch. I HIGHLY recommend this product.

Dr. Jay Stockman

.:Requirements
Computer: Minimum required by operating system you are running.
Disk Space: Under 30 MB
Operating System: Microsoft Windows 32-bit or 64-bit.
Read more...