ADSM-L

Re: SQL TDP backup not running and......

2003-02-06 18:16:01
Subject: Re: SQL TDP backup not running and......
From: Del Hoobler <hoobler AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 6 Feb 2003 16:32:03 -0500
Zoltan,

If you are not seeing anything written to the log, it means that
TDP for SQL is not even being called.
I have seen this before when there is a space in the path name.
Try changing the path name to contain quotes or use the
short name in the schedule definition.

Example:

 DEFINE SCHEDULE domain schedname ACTION=COMMAND
    OBJECTS='"D:\Program Files\TIVOLI\TSM\TDPSQL\sqlfull.cmd"'

- broken on two lines to fit in the email
- notice two sets of different quotes

Thanks,

Del

----------------------------------------------------

Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com

- Remember that the best job security is
doing a job well and doing it cheerfully.

===================================================================
> 02/06/2003 00:23:02 Executing Operating System command or script:
>    D:\Program Files\TIVOLI\TSM\TDPSQL\sqlfull.cmd
> 02/06/2003 00:23:02 Finished command.  Return code is: 1
> 02/06/2003 00:23:02 ANS1909E The scheduled command failed.
> 02/06/2003 00:23:03 ANS1512E Scheduled event 'BACKUP.ACADNT8.SQL' failed.
> Return code = 1.

<Prev in Thread] Current Thread [Next in Thread>