retrying posting...
"
-----Original Message-----
From: Williams, Tim P {PBSG}
Sent: Thursday, August 15, 2002 1:37 PM
To: 'ADSM: Dist Stor Manager'
Subject: sql and output redirection...how to..RE: Deactivate ALL admin
sch edules? (how-to)


set sqldisplaymode wide
tsm: ADSM>select 'update schedule ' || trim(schedule_name) || ' type=a
active=no ' from admin_schedules

Unnamed[1]
----------------------------------------------------------------
update schedule AM_BACKUP_DB_FULL type=a active=no
update schedule AUDIT_LICENSES type=a active=no
update schedule BACKUP_DEVCONFIG_1 type=a active=no
update schedule BACKUP_DEVCONFIG_2 type=a active=no
update schedule BACKUP_DEVCONFIG_3 type=a active=no
update schedule BACKUP_DEVCONFIG_4 type=a active=no
update schedule BACKUP_VOLHIST_1 type=a active=no

and output redirect...then execute...

FYI Thanks Tim
"


-----Original Message-----
From: Taylor, David [mailto:DTaylor AT WBMI DOT COM]
Sent: Thursday, August 15, 2002 11:09 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Deactivate ALL admin schedules? (how-to)


Hi all,

Is there anyway that I can globally set all of my admin schedules to
"ACTIVE=NO"?

I was looking for something like a standard SQL UPDATE-SET type statement,
but couldn't find anything.

I want to include this in a disaster recovery script (Korn).  The problem
that I've run into is that some of my schedule-names are longer than 16
characters (and therefor wrap).   I could probably write something (ugly and
bulky) that would work around this issue, but would prefer something
cleaner.

Additional info:

TSM server 4.2.1.15
AIX 4.3.3 ML6

TIA

David


**********************************************************************
This email 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 email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************