These steps can be used to schedule the attached VBScript, PFD_Order.vbs, which executes process flows (PFD) in the sequence coded in the VBScript instead of the order in which the PFDs appear in the SAS Enterprise Guide project.

For this example, the steps and code reference the PFDs by the names, PFD1, PFD2, and PFD3. However, any PFD names and any number of PFDs can be used as long as the VBScript is modified accordingly.

Note: This example was tested using SAS Enterprise Guide 3.0.2.446.

1. Start SAS Enterprise Guide.
2. Create a new project.
3. Click View Process Flow.
4. File New Process Flow (PFD1).
5. Add some data and add some tasks or code. When testing, it is best to keep it simple.
6. Click File New Process Flow (PFD2).
7. Add some data and add some tasks or code.
8. Click File New Process Flow (PFD3).
9. Add some data and add some tasks or code.

Test the project you just created by executing each PFD. Make sure to execute the PFDs in the correct order if they include dependant code or tasks. If you used the attached project, PFD_Order.egp, make sure you execute PFD2 first, then execute PFD1, and then execute PFD3.

10. Select File Exit. Then click 'Yes' at the prompt 'Save changes to Project?'.
11. Choose 'Local Computer' at the prompt 'Save Project To'.
12. Change the 'Save in:' location to: C:\Documents and Settings.
13. Save the project as PFD_Order.egp.

Now you are ready to create the VBScript file.

14. Download the attached zip file.
15. Select Start Programs Accessories Notepad.
16. Copy and paste the attached VBScript file, PFD_Order.vbs, into the Notepad window.
17. Select File Save As, and change the 'Save in:' location to: C:\Documents and Settings.
18. Save the VBScript as PFD_Order.vbs.

Now you are ready to test the VBScript file.

18. Make sure SAS Enterprise Guide is closed.
19. Right-click on PFD_Order.vbs and select Open. This executes the VBScript which calls and executes your project file.
20. Wait for an appropriate amount of time for the project to execute.
21. Open the project to confirm the results were regenerated.

The following steps explain how to use the Windows Scheduler to schedule the VBScript file to execute.

Note: Windows XP was used to test the following steps:

22. Access the Windows Control Panel from your client machine.
23. Select Scheduled Tasks Add Scheduled Task.
24. The Scheduled Task Wizard appears; click Next to continue.
25. Click Browse. Select C:\Documents and Settings\PFD_Order.vbs and then click Open.
26. Keep the name: PFD_Order.
27. For 'Perform this task:', choose 'One time only'; click Next.
28. Specify a Start time that is only a few minutes in the future.
29. Specify a Start date of the current date; click Next.
30. Your network user name should already be filled in.
31. Enter your network password, and confirm your password; click Next.
32. Click Finish.
33. Wait till the scheduled time has passed, and allow for an appropriate amount of time required to execute your project.

Open the SAS Enterprise Guide project to confirm the process was successful.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS Enterprise Guide	Windows	n/a

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

Type:	Usage Note
Priority:	low
Topic:	System Administration ==> Scheduling

Date Modified:	2007-11-30 15:39:37
Date Created:	2006-04-12 10:21:14