Most likely you have an issue with the database connection. First of all check
if you use database side user authentication or trusted connection. Check the version of the Oracle client files installed on the agent is compatible with the server. If not, upgrade the client. If that does not help, enable database tracing option in profile on the agent (someone has be there and click on the confirmation message) when the job starts. After the job hangs, open the trace file in notepad and check the last performed operation and the error message. : Hi,
: We have just upgraded Oracle to 9i release 2. : I have a job that is of type "run a database command"
: the command I run is : EXECUTE compaq_comm : Where compaq_comm is a stored procedure in the database : This works FINE on the master scheduler.
: But if I try to run the command on the remote agent on the machine where the
: actual database resides it just hangs completely - the job only normally
: takes 15 secs to run. : How can our upgrade have affected our database job ? Everything is the same
: apart from now the OS user on the database server has changed (but we are
: not running 24x7 as a service anyway). This is a major problem for us so
: would be VERY grateful for a speedy solution. We are connecting using the
: normal Database Profiles (ie we are NOT using ODBC). : Thanks in advance.
|
