Works great Al, thanks!
Nice solution, using select from db, but actually not selecting anything
from the db :-)


> -----Oorspronkelijk bericht-----
> Van:  Alan Davenport [SMTP:Alan.Davenport AT SELECTIVE DOT COM]
> Verzonden:    maandag 24 maart 2003 14:54
> Aan:  ADSM-L AT VM.MARIST DOT EDU
> Onderwerp:    Re: days in scripting
>
> Yes, there is. I do this in my scripts. Here is an example below:
>
>
> Name           Line       Command
>
>                Number
> ----------     ------
> ------------------------------------------------------------
> DAILY_MAI-     1          issue message i 'Starting TSM Daily
> Maintenance.'
>
>  NT
>
>                6          run healthcheck
>
>                11         select 1 from db where
> dayname(current_date)='Sunday'
>                16         if (rc_ok) goto Sunday
>
>                21         cancel expiration
>
>                26         issue message i 'Starting Backup of disc pool
> DirectoryPool
>                            to tape pool Copy_Directories'
>
>                31         ba stg directorypool copy_directories
>
>                36         issue message i 'Starting Backup of disc pool
> BACKUPPOOL to
>                            off-site tape pool COPYVAULT.'
>
>                41         ba stg backuppool copyvault maxpr=8 wait=yes
>
>                46         issue message i 'Starting Migration of files in
> disc pool to
>                            tape in pool TAPEPOOL.'
>
>                51         upd stg backuppool highm=10 lowm=0
>
>                56         delete sch migrate_check t=a
>
>                61         def sch migrate_check t=a cmd='run
> migrate_check'
>
>                            startt=now+0:10 active=y perunits=onetime
>
>                66         exit
>
>                71         Sunday:
>
>                76         issue message i 'Starting reclamation of
> partially
> full
>                            tapes.'
>
>                81         run startreclaim
>
>                86         issue message i 'Starting expiration of old data
> from the
>                            TSM database.'
>
>                91         expire i quiet=yes
>
>                96         exit
>
>
>             Take care,
>                Al
>
> Alan Davenport
> Senior Storage Administrator
> Selective Insurance Co. of America
> alan.davenport AT selective DOT com
> (973) 948-1306
>
>
> -----Original Message-----
> From: Tuyl Adrie, A.C. van [mailto:Adrie.vanTuyl AT ORANJEWOUD DOT NL]
> Sent: Monday, March 24, 2003 4:53 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: days in scripting
>
>
> Hi all,
>
> We have a daily tsm script which checks for missed backups, missed events,
> filesystems backupped longer then 24 hours ago etc.
> Weekends we do not backup all of our servers, so the check should be for
> last friday and not for sunday.
> Is there a way to implement the current day and do a jump depending on the
> current day?
>
> For instance:
>
> if 'today=monday' goto
>         q ev * * begind=-3
> else
>         q ev * * begind=-1
>
>
>
>
> Thanks,
> Adrie
>
> TSM Server 4.2.2.6 on Win NT 4 SP 6a
>
> **************************************************************************
> **
> This e-mail and any files transmitted with it are confidential and
> intended
> solely for the use of the individual or entity to whom they are addressed.
> If you have received this e-mail in error, please notify
> postmaster AT oranjewoud DOT nl
> This footnote also confirms that this e-mail message has been checked by
> McAfee Groupshield for the presence of computer viruses.
> **************************************************************************
> **
****************************************************************************
This e-mail and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this e-mail in error, please notify
postmaster AT oranjewoud DOT nl
This footnote also confirms that this e-mail message has been checked by
McAfee Groupshield for the presence of computer viruses.
****************************************************************************