Is there a way to view the current SQL that is executing while running a DBMS_JOB in 10g? When you query v$session the sql_address is set to 00 and the sql_hash_value is set to 0 for that session. Oracle version: 10.2.0.2 server: UNIX O/S: Sun Solaris 8 Thanks, Rich -- //www.freelists.org/webpage/oracle-l