Hi,
and first of all, thanks for the help you already gave me, it was really
helpfull.
I have now a problem with my SQL Server Connect Agent:
All seems to work, and then I made a change in the sqlagent dsm.opt. I
added the errorlogretention ( I've removed now), and schedlogretention.
SInce this moment, nothing works any more.
My scheduled job ( I use the the sqlfull script supplied with the SQL Agent
) returns me the following errors:
SQLSCHED.LOG
mar. 04/05/1999
21:13
ADSTAR Distributed Storage Manager
ADSMConnect Agent for Microsoft SQL Server - Version 1, Release 1, Level 1
(C) Copyright IBM Corporation 1997, 1998. All rights reserved.
ADSM API Version 3, Release 1, Level 5
ADSM Nodename: SA03001023SQL
License file exists and contains valid license data.
Logging on to the ADSM server...
ACO4218E -- Could not open the ADSM client message file (dscameng.txt).
Ensure that this file is installed in the correct location.
SQLFULL.LOG
05/04/1999
21:13:52,==================================================================
=====
05/04/1999 21:13:52,COMMAND LINE : C:\Progra~1\IBM\ADSM\agentsql\sqldsmc
/backupfull:* /truncafter
/adsmoptfile:C:\Progra~1\IBM\ADSM\agentsql\dsm.opt
/logfile:C:\Progra~1\IBM\ADSM\agentsql\sqlfull.log
05/04/1999 21:13:52,Logging on to the ADSM server...
05/04/1999 21:13:53,ACO4218E -- Could not open the ADSM client message file
(dscameng.txt).
Ensure that this file is installed in the correct location.
I verified, the dsmcamegnt.txt is located in the sqlagent directory.
When using the GUI, I can't list all the backup to make a restore. When I
try the "direct Query",
I have the same message about the dsmcameng.txt
I don't know it it is because of my new options in the dsm.opt or if it is
something else, but
I can not use my Agent anymore.
I thank you in advance for any help.
Stephanie
stephanie.canon AT cigma.asso DOT fr
|