One method to accomplish this for a UNIX environment:

Create a server command script
Create a shell script file that will run the TSM server command script like
      dsmadmc -id=admin -password=pass run dailyserverrpt >
/log/tsm/fs/tsm_server_daily_report.log
Run the shell script from a cron job at any interval you want

This is used at our site to mail out a daily server report to each of the
TSM administrators.  Works great and never fails.

Larry Peifer




             Richard Sims
             <rbs AT BU DOT EDU>
             Sent by: "ADSM:                                            To
             Dist Stor                 ADSM-L AT VM.MARIST DOT EDU
             Manager"                                                   cc
             <[email protected]
             .EDU>                                                 Subject
                                       Re: [ADSM-L] automated select
                                       statement
             04/13/2005 01:01
             PM


             Please respond to
             "ADSM: Dist Stor
                 Manager"
             <[email protected]
                   .EDU>






As mentioned in ADSM QuickFacts, it is not possible to use redirection
within server scripts. Further, as the Admin Guide says, "Scheduled
administrative command output is directed to the  activity log. This
output cannot be redirected."  Frustrating reality. Your best recourse
is the most flexible one: use dsmadmc.

   Richard Sims

On Apr 13, 2005, at 1:38 PM, 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:'.
> ...