/
Schedule of Feeds, Refreshes, Backups

Schedule of Feeds, Refreshes, Backups

Jun 14, 2012

NOC/DC MAINTENANCE WINDOW - NO FEEDS, REFRESHES, OR BACKUPS

TYPE

FOR

DESCRIPTION

TIME (PT)

TYPE

FOR

DESCRIPTION

TIME (PT)

NOC/DC MAINT

NO FEED or REFRESH ACTIVITIES

Weekly Maintenance Window

5:00 to 6:00 AM TUES - THURS

BANNER BACKUPS

TYPE

FOR

DESCRIPTION

TIME (PT)

TYPE

FOR

DESCRIPTION

TIME (PT)

BACKUP

BANNER PROD

BANNER BACKUP

12:30AM - RUNS 4HRS:15MIN TO 8HRS

FEEDS

TYPE

FROM

TO

TIME (PT)

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

TEST26 (MARIO)

TYPE

FOR

DESCRIPTION

TIME (PT)

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

SMARTSITE PRODUCTION

TYPE

FOR

DESCRIPTION

TIME (PT)

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

SMARTSITE DEV and TEST

TYPE

FROM

TO

TIME (PT)

TYPE

FROM

TO

TIME (PT)

TABLE REFRESH

SMARTSITE PROD

SMARTSITE-DEV and SMARTSITE-TEST

Sunday 3:00 to 3:15AM