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:[EMAIL PROTECTED] On Behalf Of Adrian Compton Sent: Tuesday, September 26, 2006 4:38 AM To: [email protected] 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
