ADSM-L

Re: Adding Tables to TSM Database

2006-09-26 10:29:01
Subject: Re: Adding Tables to TSM Database
From: "Colwell, William F." <bcolwell AT DRAPER DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 26 Sep 2006 10:24:28 -0400
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

<Prev in Thread] Current Thread [Next in Thread>