how to get the dbms_jobs details
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: how to get the dbms_jobs details

Hybrid View

  1. #1
    Join Date
    Sep 2001
    Location
    chennai
    Posts
    69

    how to get the dbms_jobs details

    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

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Look into DBA_JOBS for which PROCEDURE, PACKAGE or PL/SQL it triggers. Look for code in DBA_SOURCE.

    HTH
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Mar 2004
    Location
    India
    Posts
    72
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width