Site Map
.:Advanced Task Scheduler
About product
Download trial
Purchase license
Compare editions
View screenshot
FAQ & Support
Press Kit
Online manual
Blog posts
More articles...
.:Follow us
Follow us on Facebook Follow us on Twitter Follow us on YouTube


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

Categories: Manual, Shortcut type

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

I have to say you/your company has one of the best customer service setups in IT. I’m working on Saturday and you incredibly respond soon after I email! I’m a definite fan.

Jim Harrer

Computer: Minimum required by operating system you are running.
Disk Space: Under 30 MB
Operating System: Microsoft Windows 32-bit or 64-bit.