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 Articles

Advanced Task Scheduler 4.5

We’re happy to announce you that Advanced Task Scheduler 4.5 is now available. You can download it from the Download section.

In addition to several minor fixes, the most notable significant fixes and updates in Advanced Task Scheduler 4.5 are:

  • Send keys: Win key modifier added.
  • Connection watch: Network List Manager added.
  • Connection watch: “Connected for” option added.
  • Wlan connect/disconnect commands added.
  • Minor bug fixes.

Don’t wait any longer download and try Advanced Task Scheduler 4.5!

Other things you can do:

  • Spread the word about this tool
  • Follow us on Twitter
  • Like us on Facefook
  • If you ever need help, you’re always welcome to contact our professional support team
  • Read our blog to stay tuned for news, updates and everything that goes on with Advanced Task Scheduler. And do give us feedback on how we’re doing!

Advanced Task Scheduler 4.4

We’re happy to announce you that Advanced Task Scheduler 4.4 is now available. You can download it from the Download section.

In addition to several minor fixes, the most notable significant fixes and updates in Advanced Task Scheduler 4.4 are:

  • New Ribbon look and feel.
  • IE Automation shortcut type updated.

Don’t wait any longer download and try Advanced Task Scheduler 4.4!

Other things you can do:

  • Spread the word about this tool
  • Follow us on Twitter
  • Like us on Facefook
  • If you ever need help, you’re always welcome to contact our professional support team
  • Read our blog to stay tuned for news, updates and everything that goes on with Advanced Task Scheduler. And do give us feedback on how we’re doing!

IE Automation with Task Scheduler

In Advanced Task Scheduler Professional and Network starting from version 4.3 you can automate web browsing: clicking a button, entering data in a text box etc.

The automation is performed by executing series of commands against the document opened in the Internet Explorer web browser. Commands allow you to interact with controls like links, buttons, radios, checkbox, text fields etc. In order to interact with a control it has to be found in the document. A control can be found by matching one of its attributes like id, name, class etc.

An IE Automation command has four parts:
Command – command name.
Argument – name of an attrubute that will be used to find the control in the HTML document.
Value – value of the attrubute in the Argument.
Parameter – additional parameter, it is different for different commands.
You can find detailed commands and their arguments explanation in the IE Automation topic in the Online Manual.

The examples below demonstrate how to use Argument and Value in IE Automation commands to find controls in HTML documents with HTML code snippets.

GotoURL

Command Argument Value Parameter
GotoURL url http://example.com

This command navigates to the given URL and waits for it to be loaded completely. Optionally, the URL can be saved to the file specified in the Parameter instead of being opened in the browser.

ClickLink

Command Argument Value Parameter
ClickLink linktext Go Test

This command finds the link with the given text and clicks it. It will find a link represented by the HTML code like this:

<a href=”index2.php”>Go Test</a>

SetTextBox

Command Argument Value Parameter
SetTextBox name username admin

This command finds the text box with the given name and changes its text to “admin”. It will find a text box represented by the HTML code like this:

<input type=”input” name=”username”>

ClickButton

Command Argument Value Parameter
ClickButton id LoginContent_btn_Continue

This command finds the button with the given id and clicks it. Optionally, the produced content can be saved to the file specified in the Parameter, this is useful to download auto-generated files. It will find a button represented by the HTML code like this:

<input id=”LoginContent_btn_Continue” type=”submit” value=”Continue”>

SelectButton

Command Argument Value Parameter
SelectButton beforetext Remember me: check

This command finds the check box or radio button which has the given text before it and sets its state to “checked”. It will find a button represented by the HTML code like this:

Remember me: <input type=”checkbox” name=”remember”>

SelectOption

Command Argument Value Parameter
SelectOption name multi one

This command finds the select list with the given name and selects option with the value “one”. It will find a select list and option represented by the HTML code like this:

<select name=”multi” multiple size=5>
<option value=”one”>One</option>
<option value=”two”>Two</option>
</select>

Testing and Research

In the Options section of the IE Automation shortcut type, you can select the “Show browser window” option. When this option is selected the browser window will appear on the screen and you’ll be able to see how automation commands are being executed.

You can also select the “Do not close browser window when finished” option. This way the browser window will be left opened when the automation commands are finished. You can right-click anywhere on the browser window and select the “View Elements” command from the context menu. This command will show you a list of all elements with their attributes in a separate window.

IE Automation View Elements

References
IE Automation

SQL Automation with Task Scheduler

In Advanced Task Scheduler Professional and Network starting from version 4.3 you can run one or more SQL queries one by one via ODBC data sources.

This way you can execute SQL queries on any database that has its own ODBC driver. Advanced Task Scheduler can access a database by ODBC Data source or by ODBC Connection string.

ODBC Data source

You can create ODBC Data sources in the ODBC Data Source Administrator which is available from the Administrative Tools in Windows Control Panel. Each database has its own ODBC Configuration Wizard depending on its database engine.

In ODBC SQL shortcut type you only need to select the User DSN, System DSN or File DSN from the ODBC Data sources.

ODBC Connection string

The ODBC connection string consists of a set of property names and values separated by semi-colons. Basically, the properies are: the server address, database name, user name and password, but each connection string is different depending on your database engine.

In ODBC SQL shortcut type you need to enter your connection string manually in the Connection string field.

For example, to connect to the Microsoft SQL Server running on a server called ServerName, with Windows Authentication and Database called DatabaseName, you might use a connection string like this:

Driver={SQL Native Client};Server=ServerName;Database=DatabaseName;Trusted_Connection=Yes;

To connect to the PostgreSQL server running on a server called ServerName, with user and password authentication and Database called DatabaseName, you might use a connection string like this:

Driver={PostgreSQL ODBC Driver(UNICODE)};Server=ServerName;Port=5432;Database=DatabaseName;Uid=UserName;Password=Password;

To connect to the MySQL server running on a server called ServerName, with UTF8 character set and Database called DatabaseName, you might use a connection string like this:

Driver={MySQL ODBC 5.3 Unicode Driver};Server=ServerName;Port=3306;Charset=UTF8;Database=DatabaseName;Uid=UserName;Password=Password;

Note that you’ll also need to select UTF8 charset in the Options section of the ODBC SQL shortcut type properties.

Character set

The SQL query is passed to the database driver unmodified in Unicode, however, if the query returns any response such as table rows and fields, the response will be treated as if it was encoded in the character set that is specified in the Options section of the ODBC SQL shortcut type properties.

References
ODBC SQL

Advanced Task Scheduler 4.3

We’re happy to announce you that Advanced Task Scheduler 4.3 is now available. You can download it from the Download section.

In addition to several minor fixes, the most notable significant fixes and updates in Advanced Task Scheduler 4.3 are:

  • IE Automation shortcut type added.
  • ODBC SQL shortcut type added.
  • FTP download for large files fixed.

Don’t wait any longer download and try Advanced Task Scheduler 4.3!

Other things you can do:

  • Spread the word about this tool
  • Follow us on Twitter
  • Like us on Facefook
  • If you ever need help, you’re always welcome to contact our professional support team
  • Read our blog to stay tuned for news, updates and everything that goes on with Advanced Task Scheduler. And do give us feedback on how we’re doing!
   
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

We use Advanced Task Scheduler in a custom php / mysql environment for critical telecoms applications. We have found it simple to use and reliable. It does exactly what it says on the tin. The support we have received from South software for the one system glitch we have ever had was the best I have come across on the internet in over 15 years.

Thanks TipTelecom UK

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