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
   

Shortcut type

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

Python script

This shortcut type allows executing a Python script. You can find Python documentation and learn it on the official site: http://www.python.org/.

Python can be executed in two ways in Advanced Task Scheduler:

  • Internal portable Python: you do not need to install and configure Python to run Python scripts from Advanced Task Scheduler.
  • Installed Python: binary Python installation is required.

Portable Python
When the option Use internal Python interpreter in the Scripts section of the Preferences window is selected, internal portable Python interpreter is used to run Python scripts. Portable Python in Advanced Task Scheduler is built from original sources and packed into a single executable (advscheduler_python.exe). It includes all standard modules, excluding Tkinter and Distutils modules. For more information how to add modules, please see the Additional libraries section.

Installed Python
When the option Use internal Python interpreter in the Scripts section of the Preferences window is not selected, Advanced Task Scheduler searches for Python executable (python.exe) in the directories listed in the PATH environment variable. You can download and install Python from its official site: http://www.python.org/.

Arguments
The arguments are passed to the Python scripts through the advscheduler dictionary. The following keys are passed: actionschedule, actiontime, actionsource, actionsourceextra, lasterrorcode, lastexitcode. Professional and Network Editions: all defined tempfile variables are also passed. These arguments are described in the Launch application topic.

Additional libraries
This portable Python can load modules in binary form from a directory listed in the Additional library path option in the Scripts section of the Preferences window. If you need a specific module and you are a registered user, please let us know and we’ll add that module to this portable Python.

Script length
Although, the maximal length of the script is 32,768 characters, you can use the “import filename.py” construction to load another Python script file. Such files do not have length limitations.

Returning codes
Error code: Error code of starting the command
Exit code: Exit code from the script

Related Articles
Python scripting in Advanced Task Scheduler

Perl script

This shortcut type allows executing a Perl script. You can find Perl documentation and learn it on the official site: http://www.perl.org/.

Perl can be executed in two ways in Advanced Task Scheduler:

  • Internal portable Perl: you do not need to install and configure Perl to run Perl scripts from Advanced Task Scheduler.
  • Installed Perl: binary Perl installation is required.

Portable Perl
When the option Use internal Perl interpreter in the Scripts section of the Preferences window is selected,
internal portable Perl interpreter is used to run Perl scripts. Portable Perl in Advanced Task Scheduler is built from original sources and packed into a single executable (advscheduler_perl.exe). It includes all standard modules, excluding CPAN module, which can’t work with this portable Perl. For more information how to add modules, please see the Additional libraries section.

Installed Perl
When the option Use internal Perl interpreter in the Scripts section of the Preferences window is not selected, Advanced Task Scheduler searches for Perl executable (perl.exe) in the directories listed in the PATH environment variable. You can download and install Perl from its official site: http://www.perl.org/.

Arguments
The arguments are passed to the Perl scripts through the %advscheduler variable. The following keys are passed: actionschedule, actiontime, actionsource, actionsourceextra, lasterrorcode, lastexitcode. Professional and Network Editions: all defined tempfile variables are also passed. These arguments are described in the Launch application topic.

Additional libraries
This portable Perl can load modules in binary form from a directory listed in the Additional library path option in the Scripts section of the Preferences window. If you need a specific module and you are a registered user, please let us know and we’ll add that module to this portable Perl.

Script length
Although, the maximal length of the script is 32,768 characters, you can use the “require "filename.pl";” construction to load another Perl script file. Such files do not have length limitations.

Returning codes
Error code: Error code of starting the command
Exit code: Exit code from the script

Related Articles
Perl scripting in Advanced Task Scheduler

Unzip archive

This scheduled task type allows unarchiving files and folders.

Zip file
Name of zip file.

Destination folder
Destination folder to unarchive files to.

Include files
One or more file names separated by semicolon. Wildcards (“*” and “?”) are accepted. Since wildcard characters normally match directory separators (“\”), this option may be used to include any files that are in subdirectories. For example,
“1.txt” – include 1.txt file only
“sf\1.txt” – include 1.txt file from “sf” subdirectory only
“*.txt” – include .txt files from all subdirectories
“sf\*.txt” – include .txt files from “sf” and all its subdirectories
“*\*.txt” – include .txt files from all subdirectories (not from main directory)

Exclude files
One or more file names separated by semicolon. Wildcards (“*” and “?”) are accepted. Since wildcard characters normally match directory separators (“\”), this option may be used to exclude any files that are in subdirectories. For example,
“1.txt” – exclude 1.txt file only
“sf\1.txt” – exclude 1.txt file from “sf” subdirectory only
“*.txt” – exclude .txt files from all subdirectories
“sf\*.txt” – exclude .txt files from “sf” and all its subdirectories
“*\*.*” – exclude all subdirectories

Notes:

  • To unzip a single file, specify its folder, then specify its file name separately, in the Include files filed.
  • To unzip files without recursing down directories in the file system, specify “*\*.*” in the Exclude files field.
  • Zip file can include files larger than 4 GB.
  • Zip file can use UTF-8 paths.

Returning codes
Error code: Error code of starting the command
Exit code: Error code of the operation

Can be one of the following values:
0 – No error
1 – Warning error
2 – Error in zipfile
3 – Severe error in zipfile
4..8 – Insufficient memory
9 – Zipfile not found
10 – Bad or illegal parameters specified
11 – No files found
50 – Disk full
51 – Unexpected EOF
   
About us   Privacy policy   Terms of use   Link to us
Current Version: 4.5.0.616
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...