Home
SQL Spreadsheets online help Prev Page Prev Page
Introduction
About SQL Spreadsheets
Version history
Contact us
Supported database engines
Using SQL Spreadsheets
Home page
SQL workbench
Command selection
Data sets
Exporting data sets
Exporting to text files
Exporting to Excel
Define column formats
Tasks
Task settings
DATETIME tag formatting options
Connect to database
Conecting to databases directly without client libraries installed
Connecting to an Oracle database
SQL scripts
SQL tags
Image and file options
Define column formats
Delivery channels
Logging options
Finalise
Run task
Scheduling a task
Options

Scheduling a task

To run an import task non-interactively, the SQL Spreadsheets command line interface (SQLSpreadsheetsCmd.exe) is used. The first parameter must be the name of the import task file.

schedule_01a  
 
You then need to enter a name for the task, and choose the frequency to run this task.

schedule_02  
 
After you have set up the relevant schedules, you will need to enter the account details of a user that has permission to run the import. This user must also have permission to access your database if you are using Windows authentication as the logon method (e.g. for SQL Server instances).

schedule_04  
 
Once that is completed, SQL Spreadsheets will display a summary of the task settings. Click Finish to save the task into the Windows Task Scheduler.

schedule_05  
 
You can then use the Windows Task Scheduler to edit any of the task settings in the future.

schedule_09a