Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help! SQL Jobs won't run from Enterprise Manager
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.
Received on Tue Jun 09 1998 - 00:00:00 CDT