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:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 11:09 AM To: [EMAIL PROTECTED] 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 **********************************************************************