Scheduling a task

Top  Previous  Next

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

 

schedule_10

 

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

 

schedule_11

 

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_12

 

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

 

schedule_13

 

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

 

schedule_09a