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

Only the job owner can remove the job, and nothing is tracked. If you audit the connections of the job owner, you can may be find out something.
You could of course write your own wrapper for dbms_job including audit code and revoke access from dbms_job.

-- 
Sybrand Bakker
Senior Oracle DBA