SQL*SCRIPT Jobs in OEM "no output" [message #126017] |
Thu, 30 June 2005 09:54 |
smallwalker
Messages: 2 Registered: June 2005
|
Junior Member |
|
|
Hi,
would appreciate any assistance on this,
I want to run a simple selct query against one of my tables, as a sql*script job using OEM. I then want the results to the job out(i.e the query result) put to be appended to an email.
When I run the query it works, but the OEM returns with job failed, and the message;
the job failed because there was no output. In what format can one create this output, spooling does not seem to work as there are no parameter field in OEM to pick up the file???????
Thanks
Smallwalker
|
|
|