Hello
the database has got around 160 jobs. i want to find out the source code of all these jobs . how can i do this. pls help me out.
thansk in advance
rswamin
Printable View
Hello
the database has got around 160 jobs. i want to find out the source code of all these jobs . how can i do this. pls help me out.
thansk in advance
rswamin
Look into DBA_JOBS for which PROCEDURE, PACKAGE or PL/SQL it triggers. Look for code in DBA_SOURCE.
HTH
Try the following...
select stxt.sql_text,username,osuser
from v$session sess, v$sqltext stxt
where stxt.address = sess.sql_address
and stxt.hash_value = sess.sql_hash_value
--Sathy