Email msg of Mar. 7, 2002

Linda,

You mentioned how Emory simply moves their /Rptsched/schedlist to a
different file and substitute an empty file in during rebuilds.
 Then they schedule their rebuild reports etc. and replace the full
schedlist file back in place when the rebuilds are done.

From my few thoughts about this I see the following issues for LONGER than a single day downtime cases:

    -when you rename the backup file back into place on say Monday at
10:30 a.m. we would suddenly have all of our "night" reports running
like additem and adutextam and reorgthesauri etc. etc.  Of course,
running adutext during the day has never been recommended and takes
hours during the day.

I like the idea A LOT so here's how I'd make it work.

1.  -copy schedlist to say schedlist.bak

2.  -create a NON-empty file to put in its place at the appropriate time:

$ egrep "^[a-z][a-z][a-z][a-z]\|.*\|.*\|n\|" schedlist.bak > schedlist.never

cp schedlist.never schedlist

        *REASON: This new schedlist will have all the NEVER run template
reports which will be needed for the first day back up on the system.

3.  -schedule the rebuild reports

4.  -post rebuild, on first day the system is up, NEVER template reports
can be copied and run for the reports you do want to run on the first
day up on the system--avoiding additem reports, adutextam reports but
running reports like:

    -ASAP for recallsam and recall2dueam
    -ASAP remoldhold
    -ASAP oneplusholdlis (if Monday or any report that normally runs
a.m. morning system is revived)

    -schedule ONE UP reports for the first evening copy templates (or
NEVER reports--this is why I need the egrep to get the NEVER reports
into the new schedlist file) but with MODIFICATIONS for things that
target date ranges:
    -statlog as normal 17:00
    -gatelog as normal 17:05
    -dorders 17:15 ...etc.etc.

***moverdue2 and doverdues have to have modifications to cover the days
that the system was down because items COULD have fallen due during
those down days if staff inadvertantly set the date due to one of those
days****

As one schedules the reports for that evening, check each one carefully
to see if any date sensitive issues need to be dealt with for the down
days.

Ensure that reports that should have run while the system are down are
either run this evening with any special date range criteria changed as
appropriate (eg. Mackfinalist2, GLOBALordcus, MEMBordcus, STANDordcus,
SUBordcus etc.)  Remember to change the date criteria to what the report
WOULD have targetted had it been run on the appropriate day.

Now use a simple shell program called by the crontab to replace this
temporary schedlist with the old FULL original schedlist at 00:01 so
that it begins to run the full normal schedlist the day AFTER the
rebuilds are done and system has been up for awhile. (I'm writing this program today.)

Make sense?

NOTE:  I tested on nut the situation that may happen of...

when you replace the full schedlist if it sees that a weekly report e.g. Sunday night report,
didn't run this week (according to it's "knowledge" -- field 6 of the
fishbones in schedlist), will it try to run those reports now, say on
Wed. morning?  Thankfully, the answer is NO!!  Perfect.  That's what I want because I would have run that "missed" Sunday night report manually on the first day the system came "alive" with a special date selection correction -- as if it had run on Sunday night.

Situation TWO single day downtime:

This is the complex outline for a multiday DOWN time.  But  for a single day downtime like April all we'll have to do is:

Day before event:
    -suspend any reports which are scheduled to run the next morning from 00:01 through early hours which are NOT to run during the daytime during cataloging etc.
        For example for Wed Apr. 24th 2002 Seter move suspend:
            02:40 additemlistNEWINTERNET WEDNESDAY
            03:00 adutextam in text group
            03:45 reorgtext in text group
LEAVE the two recal reports
            05:00 reorgthesauri in authority group
            06:00 correcthesauri in authority group
            06:15 correcthesauri (Run twice to create x-refs)
LEAVE 06:30 remoldhold remhold in circ group
 

Suspend and run manually the following once the system is up and running on Wed. Apr. 24th:
            07:30 dailybackup (does the daily transaction backup automatically) admin group
            07:45 newcash (daily)cashbyws report in custom gro
 

crontab program (which I'll write soon) to run at 00:01 on day osiris moves to seter which does the moving of the NEVER schedlist into place of the schedlist.  (This way our evening reports run on Tuesday night Apr. 23rd).

Then once we're up and running, we can manually move the schedlist.bak back into play as schedlist (which still will have the suspended reports on it since you did it before the crontab program).

Unsuspend your daily early morning reports to being on tomorrow, or Apr. 25, Thrusday.

Nella