Setting Up Data Warehouse

Add Quartz Tool to Navigation

1 Login as admin/admin
2 Click Sites
3 Click on your CIG
4 Click Pages button to add a new page. This will add a new button to your site.
5 Click New Page at the top of the page
6 Specify a page title (i.e. Quartz Tool)
7 Click Tools button to add a new tool to your site.
8 Click New Tool at the top of the page
9 Click the radio button next to Job Scheduler Based On Quartz (sakai.scheduler)
10 Click Save
11 Go into the CIG and verify that the Quartz Tool is available.

Add the Data Warehouse Task

1 In CIG, click Quartz Tool from main navigation
2 Click Jobs link at top of page
3 Click New Job link at top of page
4 Enter a unique name in the 'Job Name' field.
5 For Type use the drop-down listbox to select Data Warehouse Update
6 Click Post

Set the trigger

1 Click Quartz Tool from main navigation
2 Click Jobs
3 Click link Triggers(0) to set the trigger.
4 Click New Trigger link at the top of the page
5 Enter a unique name for the trigger
6 Enter a cron expression that will set the server to run your job at a specific time. For examples of setting the cron trigger, go to http://www.opensymphony.com/quartz/wikidocs/CronTriggers%20Tutorial.html
If you wanted to run a set of reports on August 20, 2006 at 5:00 PM you would enter the following:
0 0 17 20 8 ? 2006
Where ? = No specific value