Run the following SQL Script to refresh the 'vw_sps_waitlist' table:
(Run daily anytime during the day, but preferably between 7:30 am and 8 am.)-----------------------------
USE [cereports]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[vw_sps_waitlist_build]
SELECT 'Return Value' = @return_value
GO
---------------------------(The following steps are inactive now)
Steps to load the waitlist data into the WaitLists_by_PID table
...
from the SSOL Waitlist view
Login to SSOL Waitlist view - You must have access to SSOL and have access to all courses mounted in SPS.
...