DBA Jobs and Errors and Stuff

-- ##############################################################################
--      DBA JOBS, ERRORS, STUFF
-- ##############################################################################

-- jobs
select * from sys.dba_jobs;
select * from sys.dba_jobs_running;
select * from sys.dba_scheduler_jobs;
select * from sys.dba_scheduler_running_jobs;
select * from applsys.fnd_tables where table_name = 'DBA_JOBS';

-- objects
SELECT * FROM all_objects WHERE object_name = 'AP_INVOICES_UTILITY_PKG';
SELECT object_type,owner||'.'||object_name FROM dba_objects WHERE status='INVALID';
SELECT text FROM dba_source WHERE name = 'AP_INVOICES_UTILITY_PKG' AND line = 2;

-- errors
SELECT line, text FROM dba_errors WHERE name = 'AP_INVOICES_UTILITY_PKG';
SELECT * FROM user_errors;
SELECT * FROM dba_errors;