Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29
dbms_job | Oracle DBA – Tips and Techniques
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Script – List status of all submitted DBMS jobs

  • Posted by Gavin Soorma
  • On July 3, 2009
  • 0 Comments
set pagesize 100 set linesize 120 ttitle - center 'Submitted DBMS Jobs' skip 2 col job format 99999 heading 'job#' col subu format a10 heading 'Submitter' trunc col lsd format a5 heading 'Last|Ok|Date' col lst format a5 heading 'Last|Ok|Time' col nrd format a5 heading 'Next|Run|Date' col nrt format a5 heading 'Next|Run|Time' col fail format 999 […]
Read More