Re: Adding Tables to TSM Database
2006-09-26 10:29:01
Hi Adrian,
you could create a master script which runs daily at 00:00 and
checks for holidays, and then inactivates schedules. A sql
statement like this can find any particular date -
select 'HOLIDAY' from status where year(current_date) = 2006 and
month(current_date) = 9 and day(current_date) = 26
Unnamed[1]
----------
HOLIDAY
Hope this helps,
Bill Colwell
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Adrian Compton
Sent: Tuesday, September 26, 2006 4:38 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Adding Tables to TSM Database
Importance: High
Hi all,
I would like to use a calendar in TSM to determine when to schedule/not
to
schedule scripts/schedules based on a calendar. The use of TSM's
dayofweek,
Month etc does not go deep enough,
and there are certain things I would like to schedule based on a
calendar
specific to my organisation i.e public holidays etc.
Can one easily add tables to the TSM database or should this be avoided.
Has anyone tried someting simliar. I am using 5.3 on AIX 5.3 (p500 LPAR)
Thanks in advance
Adrian Compton
|
|
|