Re: how can i know who drop the job

flying wrote:
> If a job is removed, how can a DBA know who did it and from which
> client station? I have looked into the online log, but found no
> evidence. the version of oracle is 9.2.0.2
>

That's precisely what auditing is for. You should come up with a plan of what do you want to audit, turn on auditing, configure auditing to audit what you want and never look into DBA_AUDIT_TRAIL again.

-- 
Mladen Gogala
http://www.mgogala.com