how to get the dbms_jobs details
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
Look into DBA_JOBS for which PROCEDURE, PACKAGE or PL/SQL it triggers. Look for code in DBA_SOURCE.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
Try the following...
from v$session sess, v$sqltext stxt
where stxt.address = sess.sql_address
and stxt.hash_value = sess.sql_hash_value
Click Here to Expand Forum to Full Width