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
   

Manual

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

ODBC SQL

This shortcut type allows executing a SQL Query via ODBC data source (Professional and Network Editions only).

If a query is a SELECT statement that returns a set of rows as output, the output will be saved in the execution log. The number of rows will be returned in the Exit code. The number of rows is the sum of number of rows affected by each query, if no rows are affected, then the number of rows in the output.

Connection string
An ODBC data source or ODBC driver connection string. ODBC connection string varies for different ODBC drivers. Please consult with your ODBC driver manual for ODBC connection string format.

SQL queries
A set of SQL queries that will be executed one by one. Queries must be properly escaped according to the database rules. Each query will be passed to the driver in Unicode. It is the driver’s responsibility to encode and collate the query.

SQL Options

Treat output charset as
Character set of the output data. This option does not affect SQL query. For example, you can pass the “Charset=UTF8;” attribute to MySQL ODBC Driver to receive output in UTF8.

Use maximum length of field
If the field data is longer than the specified length, then the data will be truncated.

Use timeout
Timeout of the operation, in seconds.

Returning codes
Error code: Error code of starting the command
Exit code: Number of rows

Related Articles
SQL Automation with Task Scheduler

IE Automation

This shortcut type allows automating Internet Explorer (Professional and Network Editions only). The automation is performed by executing series of commands against the document opened in the Internet Explorer.

Edit
Edit selected command.

Insert
Insert a new command.

Up
Move selected command up.

Down
Move selected command down.

Delete
Delete selected command.

Options
Display options window.

IE Automation Options

Show browser window
Show the browser window during executing the commands.

Do not close browser window when finished
Do not close the browser window when execution is finished.

Use timeout
Timeout of the operation, in seconds.

IE Automation Command

The table below describes IE Automation commands and their arguments.

Command Argument Value Parameter
GotoURL url URL, full path, or UNC location of the resource to display. Optional: destination file name. If specified, the URL will be downloaded to the destination location rather that opened in the browser.
GoBack
GoForward
RefreshPage
SetTextBox id The value of the “id” attribute that will be used to find the text box. Text to set to the text box field.
class The value of the “class” attribute that will be used to find the text box.
name The value of the “name” attribute that will be used to find the text box.
value The value of the “value” attribute that will be used to find the text box.
beforetext The text before the text box that will be used to find the text box.
aftertext The text after the text box that will be used to find the text box.
SetTextArea id The value of the “id” attribute that will be used to find the text area. Text to set to the text area field.
class The value of the “class” attribute that will be used to find the text area.
name The value of the “name” attribute that will be used to find the text area.
value The value of the “value” attribute that will be used to find the text area.
beforetext The text before the text area that will be used to find the text area.
aftertext The text after the text area that will be used to find the text area.
ClickLink id The value of the “id” attribute that will be used to find the link. Optional: destination file name. If specified, the target link will be downloaded to the destination location rather that opened in the browser.
class The value of the “class” attribute that will be used to find the link.
name The value of the “name” attribute that will be used to find the link.
linkurl The link URL that will be used to find the link.
linktext The link text that will be used to find the link.
ClickImage id The value of the “id” attribute that will be used to find the image. Optional: destination file name. If specified, the target link will be downloaded to the destination location rather that opened in the browser.
class The value of the “class” attribute that will be used to find the image.
name The value of the “name” attribute that will be used to find the image.
imgurl The image URL that will be used to find the image.
alt The value of the “alt” attribute that will be used to find the image.
ClickButton id The value of the “id” attribute that will be used to find the button. Optional: destination file name. If specified, the target link will be downloaded to the destination location rather that opened in the browser.
class The value of the “class” attribute that will be used to find the button.
name The value of the “name” attribute that will be used to find the button.
value The value of the “value” attribute that will be used to find the button.
beforetext The text before the button that will be used to find the button.
aftertext The text after the button that will be used to find the button.
SelectButton id The value of the “id” attribute that will be used to find the button. The Parameter can be one of the following values:
check: check the checkbox or radio button.
uncheck: uncheck the checkbox or radio button.
class The value of the “class” attribute that will be used to find the button.
name The value of the “name” attribute that will be used to find the button.
value The value of the “value” attribute that will be used to find the button.
beforetext The text before the button that will be used to find the button.
aftertext The text after the button that will be used to find the button.
SelectOption id The value of the “id” attribute that will be used to find the select list. The Argument and Value identifies the <select> list. The Parameter is the “value” attribute of the <option> within the <select> list that will be selected.
class The value of the “class” attribute that will be used to find the select list.
name The value of the “name” attribute that will be used to find the select list.
beforetext The text before the select list that will be used to find the select list.
aftertext The text after the select list that will be used to find the select list.
UnselectOption id The value of the “id” attribute that will be used to find the select list. The Argument and Value identifies the <select> list. The Parameter is the “value” attribute of the <option> within the <select> list that will be unselected.
class The value of the “class” attribute that will be used to find the select list.
name The value of the “name” attribute that will be used to find the select list.
beforetext The text before the select list that will be used to find the select list.
aftertext The text after the select list that will be used to find the select list.
WithFrame id The value of the “id” attribute that will be used to find the frame.
class The value of the “class” attribute that will be used to find the frame.
name The value of the “name” attribute that will be used to find the frame.
framesrc The value of the “src” attribute that will be used to find the frame.
EndWithFrame
IfExists id The value of the “id” attribute that will be used to find the element. Type of the element to check its existence. The following values can be specified: TextBox, TextArea, Link, Image, Button, Select, Frame.
class The value of the “class” attribute that will be used to find the element.
name The value of the “name” attribute that will be used to find the element.
beforetext The text before the element that will be used to find the element.
aftertext The text after the element that will be used to find the element.
EndIfExists
Wait Number of seconds to wait.

Internet Explorer 8 is recommended for this shortcut type. Internet Explorer 5.5 is the minimum required browser for this shortcut type in Advanced Task Scheduler 4.3. There are known issues with Internet Explorer versions prior version 8, such as error 800C0008 on GotoURL.

Returning codes
Error code: Error code of starting the command
Exit code: Number of commands executed

Related Articles
IE Automation with Task Scheduler

Holiday properties

In Advanced Task Scheduler Professional and Network Editions it is possible to run a task on work days, non-work days or holidays.

Generally, there are two ways no define a holiday in Advanced Task Scheduler: specify fixed dates or allow Advanced Task Scheduler to calculate date of a holiday using common techniques such as first/second/etc. weekday on or preceding/after the day of the month, weekday nearest to the day of the month, Western/Orthodox/Julian Easter, and so on.

A holiday can belong to one of three predefined categories: Public Holiday, Non-holiday Observance or User Event. The categories can be used to run different tasks with different holiday sets.

Public holidays are respected when you select work days or non-work days options in other schedule types.

Related Articles
Holiday Aware Task Scheduler

   
About us   Privacy policy   Terms of use   Link to us
Current Version: 5.0.0.700
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 use Advanced Task Scheduler to run my backups jobs. After performing a backup by standard Windows 2003 Server means, Advanced Task Scheduler launches a script which copies files. I am glad I chose your program.

Rob Hannigan

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