Synametrics Technologies

Database task scheduler

A built-in task scheduler in WinSQL will allow users to schedule tasks that can be run on a user defined schedule. This task scheduler is tightly integrated with Microsoft Windows Operating System.

Type of tasks

The following type of tasks can be scheduled:

• Running SQL scripts
• Exporting data from one source to another target
• Exporting data to HTML files
• Running Data Diff and Schema Diff wizards

Running SQL scripts

Running SQL scripts based on a schedule is the most powerful and useful feature of Task Scheduler. Follow the steps below to create a task that runs SQL scripts:

1. Save your SQL queries to a file with .SQL extension
2. Start WinSQL and connect to your desired database
3. Click Tools/Scheduler ... on the main menu
4. The following window opens up
   
5. Double click <Add New Task> or click the Add Task button
6. Following window is displayed
   

   Task Name: User defined name for this task. Task Type: Type of task to run. Email Status: Configure status email by selected appropriate value. Attach output file in email: Check if you wish to attach the output file in the status email Terminate WinSQL: Check to terminate WinSQL once task is completed Script file name: Name of the file you saved in step 1 Output file name: Output file. This will hold any results as well as error/warning messages returned back from the database.

7. Specify desired parameters
8. If you decide to send status emails, you must configure outbound email parameters. This is done by clicking the Configure email server button
   
9. The following screen is used to configure email servers.
   
10. Click Ok to close the window and go back to the previous screen
11. Now you should see your newly created task in the main scheduler window
12. Click Modify Schedule button to assign a schedule to this task
13. IMPORTANT: WinSQL is tightly integrated with the OS for task scheduling. Therefore, your login ID must have sufficient rights to run tasks on the machine
14. The Task scheduling screen is part of the OS therefore you should consult the documentation for Windows for further information regarding scheduling.