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
   

Southsoftware

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!

Holiday Aware Task Scheduler

In Advanced Task Scheduler Professional and Network Edition you can run tasks on holidays, or avoid running tasks on holidays.

  • If you wish to start a task on either a single holiday or all holidays, you can use the “Run on holiday” schedule type with the “Run on the day of holiday” option.
  • If you wish to start a task on all days except either a single holiday or all holidays, you can use the “Run on holiday” schedule type with the “Run on all days except holiday” option.
  • If you wish to start a task on work days only, excluding holidays and non-work days such as Saturday and Sunday, you can use the “Run weekly” schedule type with the “Work days only” option selected.
  • If you wish to start a task on non-work days only, including holidays and non-work days such as Saturday and Sunday, you can use the “Run weekly” schedule type with the “Non-work days only” option selected.
  • If you wish to set up work days and holidays, go to the “Holidays” section on the user’s tab of the “Preferences” window.
  • If you wish to preview days when the task will start in the future, you can use the “View start time” button on the “Schedule” tab of the “Task Properties” window.

References
Holiday Properties

Advanced Task Scheduler 4.2

We’re happy to announce you that Advanced Task Scheduler 4.2 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.2 are:

  • Fixed problem with “Service failed to start” during setup.
  • Fixed error in FTP download/delete operations.
  • Added support for utf8 file names in FTP operations.
  • Added SSL/TLS option to support FTP over SSL.
  • Improved SFTP support.
  • Added support for SFTP RSA keys.
  • Added support for FTPS certificate authentication.
  • Added support for HTTPS certificate authentication.

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

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!

Terminal Server Aware Task Scheduler

There are explanations of Terminal Server features spread over the user manual, but to make it easy for the users who need Terminal Server features we’ll explain how Advanced Task Scheduler works from the Terminal Server’s point of view in this post.

Terminal Sessions are supported in Network edition and in All Users tab in Basic and Professional editions. A scheduled task may run on the active terminal session, or a separate instance of a task will run on each session. It’s not exactly each session; they may be filtered by user name, so the task will run only on sessions, whose user is on the list. Normally, task runs under the same credentials as Terminal Session’s user, “Active user” is the default option, however, you can set up it to run under different credentials.

Let’s consider and example where you are running a Terminal Server and wish to run a program on each session at the specified time. You create a task with appropriate schedule type, set the “Run this task for each logged on and valid user” option on the “User Account Options” tab of the Task Properties window, then the task will run on each Terminal Session at the specified time. A valid user means that the system and inactive terminal sessions are ignored.

Should you wish to run your task for only the sessions where the specific user is logged on, set the “Start this task only if one of the following users is logged on and active” and fill the list of user names.

In Advanced Task Scheduler 4.1 we extended the number of statements that you may use in your task. These statements include checking if a specified file exists or locked and checking user’s idle time. All these checks are performed taking into account the session/user under which the task is being executed.

In conclusion, we encourage you to try Advanced Task Scheduler as a solution to run scheduled tasks on a Terminal Server.

References
User Account Options

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