| retrieve deleted data of user_jobs [message #430050] |
Sat, 07 November 2009 10:29  |
spur230
Messages: 5
Registered: April 2009
Location: US |
Junior Member |
|
|
Hello All,
I had scheduled a job in oracle 10g to run only once using dbms_jobs.
I wanted to find out how long the job took ( total_time) and what SQL it was running ( user_job.what) but the information about the job seem to get deleted from user_jobs once the job is completed.
Is there any other table/ view I can use to find these information?
Also, will it be possible to query the user_job as of previous time when the data was there? if yes, please also let me know what privilidges and setting is required. Currently, I just have basic developer priviledge.
Many thanks in advance for any help. 
|
|
|
| Re: retrieve deleted data of user_jobs [message #430053 is a reply to message #430050] |
Sat, 07 November 2009 11:26  |
Michel Cadot
Messages: 29395
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
If the job is a one-shot it is removed from the table as soon as it is executed.
There is no way to know it existed.
Just like there is no way to know from what someone executed a SQL when it is over (assuming there is no trace and no audit activated).
Regards
Michel
|
|
|
] 
Members
Search
Help
Register
Login
Home
