What quotes ?

I don't have any quotes around the command (or at least the GUI client
doesn't show any ??) ??

Do I need them ?  Which ones ?      I never could find a good example in
any of the books !  Especially since the default installation path is
D:\Program Files\Tivoli\TSM\TDPsql    ?????????????





Thomas Denier <Thomas.Denier AT MAIL.TJU DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
09/04/2001 10:12 AM
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: TDP MS SQL client errors


Quoting Zoltan Forray/AC/VCU <zforray AT VCU DOT EDU>:

> I am seeing the following errors in my dsmerror.log after a scheduled
> CMD:
>
> 09/03/2001 19:26:19
> Executing Operating System command or script:
>    D:\Program Files\TIVOLI\TSM\TDPSQL\sqlfull.cmd
> 09/03/2001 19:26:20 Finished command.  Return code is:
>    1
> 09/03/2001 19:26:20 ANS1512E Scheduled event 'BACKUP.ACADNT3.SQL'
> failed.
> Return code = 1.
> 09/03/2001 19:26:20 Sending results for scheduled event
> 'BACKUP.ACADNT3.SQL'.
> 09/03/2001 19:26:21 Results sent to server for scheduled event
> 'BACKUP.ACADNT3.SQL'.
>
> How do I figure out what is happening ?
>
> I can execute the sqlfull.cmd file manually, and it works just fine.
>
> I don't see anything in the tdpsql backup logs or error files ????

I suspect that you have a problem with nesting of quotation marks.
Because of the embedded blank in "Program Files", the command sent
to the client has to enclosed in double quotes:

"D:\Program Files\TIVOLI\TSM\TDPSQL\sqlfull.cmd"

The objects operand of the 'define schedule' or 'define clientaction'
command has to use single quotes to protect the double quotes from
being removed by TSM itself:

objects='"D:\Program Files\TIVOLI\TSM\TDPSQL\sqlfull.cmd"'