In this topic you will learn how to Schedule a Single Query.
NOTE: This topic demonstrates how to schedule one query at a time for view.
Queries may be scheduled through use of the Process Scheduler and viewed through the Report Manager. This is a valuable tool when a query is large and takes a long time to run. Scheduling your query allows you to run the query at a time when there is less activity on the system.
In this exercise, you will schedule the LSU_VENDORS_W_ADDRESS query to run in 5 minutes.
Enter the desired information into the Run Control ID field. Enter "SCHED_QUERY".
Enter the desired information into the Description field. Enter "VENDOR ADDRESS LIST".
You must select the Server on which the query will run. The Server is always PSNT.
You will schedule the query to run 5 minutes from the time displayed in the Run time field. In this example, you will enter 4:05 PM into the Run Time field.
Click the Link displaying in the Description column to view the results. This will open a new window.
NOTE: If multiple processes, queries, and/or reports have been run by the user, the most current will display at the top of the list.
Once the results display, you can use any functionality in Excel to manipulate the results.
The system defaults you to the Add a New Value tab. A Run Control ID must be added the first time you run a query.
The Run Control ID is used to access the Process Scheduler. The Run Control ID is:
1. Specific to the UserID;
2. Can be entered in upper, lower or mixed case;
3. Can be up to 30 characters long; and
4. Must be one continuous string of words. It cannot contain any blank spaces. If you wish to separate two words, connect them using an underscore.
Once the scheduled time has elapsed, and the query runs, you can view the query results via the Report Manager.
This completes Schedule Queries.
Enter the desired information into the Run Control ID field. Enter a valid value e.g. "SCHED_QUERY".
Enter the desired information into the Description field. Enter a valid value e.g. "VENDOR ADDRESS LIST".
You will schedule the query to run 5 minutes from the time displayed in the Run time field. In this example, you will enter 4:05 PM into the Run Time field.