Schedule of Feeds, Refreshes, Backups

TYPE	FOR	DESCRIPTION	TIME (PT)
NOC/DC MAINT	NO FEED or REFRESH ACTIVITIES	Weekly Maintenance Window	5:00 to 6:00 AM TUES - THURS

TYPE	FOR	DESCRIPTION	TIME (PT)
BACKUP	BANNER PROD	BANNER BACKUP	12:30AM - RUNS 4HRS:15MIN TO 8HRS

TYPE	FROM	TO	TIME (PT)
FEED	Daily_iris_prod_SAKAI_Feed (IRIS - SIS, mothra, unex, and degree navigator feeds)	SMARTSITE PROD	3:00 to 3:15 AM
FEED	LOBO - SIS_TESTX, SIS_DEVX - mothra, unex, and degree navigator feeds	TEST26	3:00 to 3:30 AM

TYPE	FOR	DESCRIPTION	TIME (PT)
BACKUP	MARIO - TEST26	Export backups	4:00 to 4:45 AM
PROD SNAPSHOT	MARIO - TEST26	Daily export from Prod Daily import to Test26 (Mario)	5:00 to 8:30 PM - Export 1:00 to 2:00 AM - Import

TYPE	FOR	DESCRIPTION	TIME (PT)
BACKUP	METALLICA - SMARTSITE PROD	PROD DB	1:00AM
TABLE REFRESH	METALLICA - SMARTSITE PROD	Table refresh	4:00 AM (doesn't run on Saturday) 12:00 noon 6:00 PM 00:00 AM (doesn't run on Saturday) Note: The CRON job needs to be adjusted for spring and fall time changes for differences between MST and PST/PDT. PST/MST for Fall cron job times are: 00 01,05,13,19 * * * /home/oracle/scripts/jobs/refresh.sh ucdsakai >> /dev/null 2>&1 PDT/MST for Spring cron job times are: 00 00,04,12,18 * * * /home/oracle/scripts/jobs/refresh.sh ucdsakai >> /dev/null 2>&1

TYPE	FROM	TO	TIME (PT)
TABLE REFRESH	SMARTSITE PROD	SMARTSITE-DEV and SMARTSITE-TEST	Sunday 3:00 to 3:15AM