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
   

Troubleshooting

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

Scheduled Tasks location and upgrade compatibility

Advanced Task Scheduler 5.0 and later stores its settings and scheduled tasks in the SQLite database file. You can find storage location, files and upgrade compatibility in the table below:

Product Edition User Registry key Directory File Upgrade compatibility
Advanced Task Scheduler version 5.0 and later Basic Current User HKEY_CURRENT_USER\Software\Southsoftware\AdvScheduler Value of “SettingsDir” of the Registry key. tasks.sqlite
All Users HKEY_LOCAL_MACHINE\Software\Southsoftware\AdvScheduler allusers.sqlite
Professional Current User HKEY_CURRENT_USER\Software\Southsoftware\AdvSchedulerPro tasks.sqlite
All Users HKEY_LOCAL_MACHINE\Software\Southsoftware\AdvSchedulerPro allusers.sqlite
Network All Users HKEY_LOCAL_MACHINE\Software\Southsoftware\AdvSchedulerNet allusers.sqlite
Advanced Task Scheduler version 2.0 – 4.5 Basic Current User HKEY_CURRENT_USER\Software\Southsoftware\AdvScheduler There are no Directory and File as everything is stored inside the Registry key. Advanced Task Scheduler 5.0 and later automatically converts settings and tasks to SQLite database file. Either backup.reg.bak or settings.ini.bak, tasklist.ini.bak, templog.ini.bak files are created in the Directory with full backup of all settings and tasks before they are removed from the system.
All Users HKEY_LOCAL_MACHINE\Software\Southsoftware\AdvScheduler
Professional Current User HKEY_CURRENT_USER\Software\Southsoftware\AdvSchedulerPro Value of “SettingsDir” of the Registry key. If Directory value is empty string or it does not exist then there are no File as everything is stored inside the Registry key. Otherwise the files are: settings.ini, tasklist.ini, templog ini.
All Users HKEY_LOCAL_MACHINE\Software\Southsoftware\AdvSchedulerPro
Network All Users HKEY_LOCAL_MACHINE\Software\Southsoftware\AdvSchedulerNet
Advanced Task Scheduler versions 1.0 – 1.5 Current User and All Users HKEY_CURRENT_USER\Software\Southsoftware\Scheduler
and if you are running Advanced Task Scheduler as service:
HKEY_USERS\.DEFAULT\Software\Southsoftware\Scheduler
There are no Directory and File as everything is stored inside the Registry key. Advanced Task Scheduler 2.0 and later does not import task list from Advanced Task Scheduler 1.x automatically. You have to use the “Export tasks” command from the “File” menu of Advanced Task Scheduler 1.x to export task list to a file, then use the “Import” command from the “File” menu of Advanced Task Scheduler 2.0 and later to import task list from that file.

Related Articles
Advanced Task Scheduler’s SQLite database

Public key and Certificate authentication

Advanced Task Scheduler 4.2 and later supports public key and SSL Certificate authentication in HTTPS, FTPS and SFTP operations. You can enable these options when you are editing an HTTP or FTP shortcut type in the Task properties window. This section describes the format of the key files.

SFTP public key
The key file should contain SFTP Public key in pem format. Usually this file is named id_rsa and it is in pem format by default.

The pem file should look like this:

-----BEGIN RSA PRIVATE KEY-----
Proc-Type: 4,ENCRYPTED
DEK-Info: AES-128-CBC,7F0160D277DECF3E6OA921E9C8AF1E32

4gBhh8JELjeXFcpFfzpFeAuTBI3t7XJpmJbArH7BZnfBJKb4FEnstr6pf72UF1RM
SnsBPn00aQfX61lLom5FlJyk82etFbJoS3RgrW2na7HXTqsCGdkoh4E1Mwv0XDho
hlKO6T0kh9u5wIaQmIqSTZD5hqTavK6dboAKO8ftdQSuNLJIusSYT7Lps7ciVIFh
-----END RSA PRIVATE KEY-----

HTTPS and FTP SSL Certificate and Private key
The key file should contain SSL Certificate and Private key in pem format.

The pem file should look like this:

-----BEGIN RSA PRIVATE KEY-----
OmutTanx1rkczvfrkKOpGEdqTrJEP0bT5B3Lzw8IDq8Je8B8AzUwmtKTKY7cFK7Q
AhW9BGToO7wDlFUbRh5EnK5CLkJa0cQWLua3ibfum4mBe8itIPZnRQlM4elVtPeG
HE7bsWg62pS9x59U1WPkeBwQygpYgo4znpW7slslAgTTYON5FeYWTFu9SuRrSncx
-----END RSA PRIVATE KEY-----
-----BEGIN CERTIFICATE-----
wXO5hfuNcwsK4rqGhMIWJGRtKW7uJwzi58nSGZKZw6QhjL2OZORWQoq
S7z6po4Loa3YZXcW5DMKZXiaV37TXAMiQNYnBQEsrSq4FCOGCatoEoP5ZN2vfeCf
7CaeRaSokm8ecNwShlUoaQxAhlz1sAJRvcnJcyPRsnG6vBXWOGvPyZwyiuTJXcDh
-----END CERTIFICATE-----

Key Password
Password for the SFTP Public key or SSL Private key. Leave this field blank if password is not required.

Service Running as System Account Fails Accessing Network

By default, Advanced Task Scheduler service is registered to run as the system user (the LOCAL SYSTEM account). Generally, the default service account, LOCAL SYSTEM, has full privilege on the local machine but NO PRIVILEGE on a remote system. So any request to access a remote resource like your files will fail.

If you need Advanced Task Scheduler to be able to access network resources, change user account for Advanced Task Scheduler Service from LOCAL SYSTEM to an administrator account. To change service account go to Control Panel | Administrative Tools | Services, double click Advanced Task Scheduler Service and specify user account on the Log On tab of the Service Properties window.

System automatically enters sleep after waking from sleep

Windows Vista and later versions of Windows go back to sleep or hibernate automatically after a specified period of time if you do not touch the mouse or keyboard. The default time is set to 120 seconds.

To change that value, open the REGEDIT tool, then select the following key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Power\PowerSettings\238C9FA8-0AAD-41ED-83F4-97BE242C8F20\7bc4a2f9-d8fc-4469-b07b-33eb785aaca0\DefaultPowerSchemeValues

System automatically enters sleep after waking from sleep

The DefaultPowerSchemeValues key contains three subkeys, which correspond to Balanced, High Performance, and Power Saver options. You need to change the ACSettingIndex and DCSettingIndex values in all three keys. You can either set a period longer than the maximum anticipated duration of the run of the scheduled task (in seconds) or set 0 to turn off this feature.

References

Power Policy Configuration and Deployment in Windows

   
About us   Privacy policy   Terms of use   Link to us
Current Version: 5.1.0.701
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

A few years ago I got a license to Advanced Task Scheduler Professional for translating it to my native language. Thank you very much for the software, I really appreciate your software.

M. Andersen

.: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...