Scheduling an Order Task

Steps to create the SQL and Batch files to set Order Task/Reminders

1. Create SQL file for executing the generateautomatedactivity procedure.

Create a ASCII file with extension .SQL enter the below command lines and save the file.

exec generateautomatedactivity

exit;

2. Creating a batch file for executing automation procedure.

Create a file with extension .Bat file with the following command line and save the file in the same folder where the .SQL file is stored.

Sqlplus username/password @connectstring @ [filename].sql

Step to do the Scheduling Automation procedure

1. To open Scheduled Tasks, click Start, click All Programs, point to Accessories, point to System Tools, and then click Scheduled Tasks.

2. Double-click Add Scheduled Task to start the Scheduled Task Wizard, and then click Next in the first dialog box.

3. The next dialog box displays a list of programs that are installed on your computer, either as part of the Windows operating system, or as a result of software installation.

4. Click Browse & locate the folder where .BAT file created in Step 2 is saved.

5. Select the file  and click Open.

6. Enter a name for the new schedule, say Order task automation.

7. Select Daily as the Perform this task option and then click Next.

8. Specify the information about the day and time to run the task.

9. Select Start date for the new schedule and then click Next.

10. Type the name and password of the user who is associated with this task. Make sure that you choose a user with sufficient permissions to run the program. By default, the wizard selects the name of the user who is currently logged on.

11. Click Next to display the dialog box with information about the choices that you have made.

12. Select Open Advanced properties for this task (On selecting this option, Windows will display properties dialog box for the scheduled task when the create schedule wizard is closed).

13. Click Finish to close the wizard, and display the schedule properties dialog box.

14. Click on the Settings Tab.

15. De-select the options which are highlighted (as shown below).

16. Click OK to save & exit schedule configuration window.