Versions Compared

Old Version 55

changes.mady.by.user Joyce Johnstone

Saved on

compared with

New Version Current

changes.mady.by.user Joyce Johnstone

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

TYPE

FOR

DESCRIPTION

TIME (PT)

BACKUP

MARIO - TEST26

Export backups

4:00 to 4:45 AM

TABLE REFRESH PROD SNAPSHOT

MARIO - TEST26

Table refresh

3 Daily export from Prod
Daily import to Test26 (Mario)

5:00 to 38:30 AM PM - Export
3 1:00 to 3:30 PM 2:00 AM - Import

SMARTSITE PRODUCTION

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

...