Home » RDBMS Server » Server Administration » job save where?
job save where? [message #61795] Fri, 28 May 2004 05:32 Go to next message
just a test
Messages: 3
Registered: August 2003
Junior Member
Hi

When we create a new job, where is this stored, are those editable? or encrypted?, I need to recover a job and I don't see it on my library.
Re: job save where? [message #61797 is a reply to message #61795] Fri, 28 May 2004 09:05 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
select * from user_jobs;

Simply delete the entry you don't want (dbms_job.remove) and re-submit the "edited version" with dbms_job.submit. Don't forget to commit.
Re: job save where? [message #188031 is a reply to message #61795] Wed, 16 August 2006 17:30 Go to previous messageGo to next message
aimy
Messages: 225
Registered: June 2006
Senior Member
I have the same problem!! Sad

I've mistakenly submit a job thorugh OEM without saving it to my library.. ;(

So, how do I know under which user the job runs??

Is it from the login user that I used to log in to the Oracle Manager Server - OEM??

Really really need help!! This is quite urgent..

Thank you very much.
Re: job save where? [message #188043 is a reply to message #188031] Wed, 16 August 2006 19:49 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
aimy wrote on Wed, 16 August 2006 17:30

I have the same problem!! Sad

I've mistakenly submit a job thorugh OEM without saving it to my library.. ;(

So, how do I know under which user the job runs??

Is it from the login user that I used to log in to the Oracle Manager Server - OEM??

Really really need help!! This is quite urgent..

Thank you very much.


Why are you responding to an old thread?

As for your problem, what type of job did you create? If you didn't specify a user, it should run under the Preferred Credentials you have configured. Does the submitted job show up in the History pane?

[Updated on: Thu, 17 August 2006 06:29]

Report message to a moderator

Previous Topic: to find object in buffer pool
Next Topic: simple DBA problem
Goto Forum:
  


Current Time: Fri Sep 20 10:47:26 CDT 2024