Re: Help! SQL Jobs won't run from Enterprise Manager

I thought you had to run the intelligent agent to pick up the job request? What do the docs say?

hth -

Regards,
jh

Doug Chernoff (dchernoff_at_home.com) wrote:
: Hi Greg,
 

: This is one of the few things that seems to work on my system.
 

: I'm using OEM version 1.3.5 against a 7.3.2.3.6 database (both on the same NT
: workstation for now).
: When doing an NT search on the workstation for sqlplus I get:
: sqlplus.exe in C:\ORANT\BIN
: sqlplus.tcl in C:\ORANT\NETWORK\AGENT\JOBS\ORACLE\RDBMS\GENERAL
 

: It's my guess that you need both of these on the server you're trying to execute
: against.
 

: Regards.

: Greg Frizzle wrote:
 

: > We are trying to create a job that simply runs a SQL statement, but we
: > aren't having much luck. (By the way, we're Oracle 7.3.2.3.8, and Enterprise
: > Manager 1.5.) When creating the job, I select "Run SQL * Plus" from the list
: > of Tasks, and I just put a simple "SELECT * FROM SCOTT.EMP" in the Script
: > Text box on the Parameters tab.
: >
: > When I submit the job, it comes back with a Failed status. The message is
: > "nms-1013: sqlplus does not exist". It definitely does exist on the server.
: > The only help we've gotten from the books were to check to see of the agent
: > can run server manager, which it can. Has anyone experienced this? Does
: > anyone know exactly what executable the job is expecting to see? Any help
: > would be greatly appreciated.

--
Jared Hecker	| HWA Inc. - Oracle architecture and Administration
jared_at_hwai.com	|  ** serving NYC and New Jersey **