DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: how to get the dbms_jobs details

  1. 04-23-2004, 01:23 AM #1
    rswamin
    rswamin is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 04-23-2004, 01:54 AM #2
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    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"
    Reply With Quote Reply With Quote
  3. 04-23-2004, 01:58 AM #3
    Sathy
    Sathy is offline Junior Member
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width