I created a schedule using "run make_get > c:\automation\temp\list.txt" And I changed the make_get so that it only had the select statement. It didn't work. It dumped the results of the select statement to the act log.
-----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andy Carlson Sent: Wednesday, April 13, 2005 1:45 PM To: [email protected] Subject: Re: [ADSM-L] automated select statement Try taking the redirection out of the script, and put it on the run line. Tyree, David wrote: > I'm trying to send the results of a select statement to a > text file within TSM as a scheduled job. > > It works just fine if I run it from the console. If I try to > schedule it within TSM then it will fail: > > > > tsm: BACKUP1>run make_get > > ANR2913E Invalid SQL identifier token - 'C:'. > > ............................ > ....................................V.......................... > > DIA WHERE STATE='COURIERRETRIEVE' > c:\automation\temp\list.txt > > > > ANR1463E RUN: Command script MAKE_GET completed in error. > > ANS8001I Return code 4. > > > > Here's the command I'm trying to run: > > > > SELECT VOLUME_NAME as "Tape Number" FROM DRMEDIA WHERE > STATE='COURIERRETRIEVE' > c:\automation\temp\list.txt > > > > I've tried different variations within TSM as a scheduled > command but I get basically the same type of error referring to invalid > SQL identifier token. If I just run the select statement as a scheduled > job without the redirect then the results will show up in the activity > log. That tells me that I'm close to getting it to do what I want it to > do. > > I've looked around the QuickFacts website and the adsm.org > website but didn't see anything useful in this situation. > > Is this even possible? > > > > TSM version 5.2.2 running on a Win2k box. > > > > > > David Tyree > Enterprise Backup Administrator > South Georgia Medical Center > 229.333.1155 > > Confidential Notice: This e-mail message, including any attachments, is > for the sole use of the intended recipient(s) and may contain > confidential and privileged information. Any unauthorized review, use, > disclosure or distribution is prohibited. If you are not the intended > recipient, please contact the sender by reply e-mail and destroy all > copies of the original message. > > > > > -- Andy Carlson - Senior Technical Specialist BJC Healtcare ------------------------------------------------------------------------ --- Gamecube:$150,PSO:$50,Broadband Adapter: $35, Hunters License: $8.95/month, The feeling of seeing the red box with the item you want in it:Priceless.
