Dear all,I have a scheduled agent in my web application which updates BD2 files. I connect to DB2 using server ODBC connection. when i run the agent on web(manually) it runs. But it doesn’t run on schedule.
Please help me
Shana
Subject: ODBC Scheduled Agent not run on schedule
It works when you run it manually because it will be using the ODBC data source configured locally on your PC.
In order for the agent to run on schedule, you must make sure that there is a correctly configured ODBC datasource on the Domino server.
Be aware that if you are using a mapped drive to the data source this will cause issues as well.
I would use LSX Lotusscript connectors and use a proper DB2 connection instead of ODBC.
HTH
Subject: RE: ODBC Scheduled Agent not run on schedule
If I may take it one step further, you could use JDBC. I have found that it works the best out of all the choices