The only thing I can think of is a dummy select that does something like this:
SELECT 'RUN MORNING' FROM NODES where node_name='YOUR_TSMSERVER' That will only find the entry in the nodes table and put out that line from the select. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -----Original Message----- From: Coats, Jack [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 9:06 AM To: [EMAIL PROTECTED] Subject: Documenting a Script in TSM There is probably a simple answer... I am running a script from TSM on NT with several commands that do SQL Queries and TSM commands each morning. How can I do the equivalent of an 'Echo' or 'Type' command in the scripts to put a text 'header' of sorts out before each of the commands? Example: I do a 'RUN MORNING' from my web browser TSM command line. It executes the following commands: /* Morning Report */ /* */ /* First, Copy Pool Tapes to go off site */ query volume * access=readw,reado - status=full,filling stgpool=copypool /* */ /* Second, List TODAYs DataBase backup tape */ query volhist type=dbbackup begindate=today /* */ /* Third, List the volumes ready to come on-site */ query volume * access=offsite status=empty /* */ /* Fourth, List all the events in the last */ /* work day that should have been completed */ QUERY EVENT * * BEGINDATE=TODAY-1 - BEGINTIME=08:00 ENDDATE=TODAY ENDTIME=08:00 - EXCEPTIONSONLY=NO FORMAT=STANDARD /* */ /* Fifth, Query the journal logs and the */ /* database for their size, 80% is needs */ /* some attention */ query log query db /* Library Volumes */ query libv /* All Volumes in Catalog */ query vol /* Space Usage - q occupancy */ query auditoccupancy /* Storage Group Status */ query stg And I just want to put what is in the comments out to the display along with the results of the commands. Suggestions?
