SELECT OWNER, JOB_NAME, JOB_SUBNAME, JOB_CREATOR, CLIENT_ID,
GLOBAL_UID, PROGRAM_OWNER, PROGRAM_NAME, JOB_TYPE, JOB_ACTION,
NUMBER_OF_ARGUMENTS, 
SCHEDULE_OWNER, SCHEDULE_NAME, SCHEDULE_TYPE, TO_CHAR(START_DATE,'DD-MON-YYYY') START_DATE,
EVENT_QUEUE_OWNER, EVENT_QUEUE_NAME, EVENT_QUEUE_AGENT, EVENT_CONDITION,
EVENT_RULE, TO_CHAR(END_DATE,'DD-MON-YYYY') END_DT, JOB_CLASS, ENABLED, AUTO_DROP,
RESTARTABLE, STATE, JOB_PRIORITY, RUN_COUNT, MAX_RUNS,
FAILURE_COUNT, MAX_FAILURES, 
RETRY_COUNT, TO_CHAR(LAST_START_DATE,'DD-MON-YYYY') LAST_START_DT, LAST_RUN_DURATION,
TO_CHAR(NEXT_RUN_DATE,'DD-MON-YYYY') NEXT_RUN_DATE, SCHEDULE_LIMIT, 
MAX_RUN_DURATION, LOGGING_LEVEL, STOP_ON_WINDOW_CLOSE,
INSTANCE_STICKINESS, RAISE_EVENTS, SYSTEM, JOB_WEIGHT, NLS_ENV,
SOURCE, DESTINATION, COMMENTS, FLAGS
FROM dba_scheduler_jobs where job_name LIKE '%IT%'

SELECT owner,
       job_name,
       job_subname,
       job_creator,
       client_id,
       global_uid,
       program_owner,
       program_name,
       job_type,
       job_action,
       number_of_arguments,
       schedule_owner,
       schedule_name,
       schedule_type,
       To_char(start_date, 'DD-MON-YYYY')      start_date,
       event_queue_owner,
       event_queue_name,
       event_queue_agent,
       event_condition,
       event_rule,
       To_char(end_date, 'DD-MON-YYYY')        end_dt,
       job_class,
       enabled,
       auto_drop,
       restartable,
       state,
       job_priority,
       run_count,
       max_runs,
       failure_count,
       max_failures,
       retry_count,
       To_char(last_start_date, 'DD-MON-YYYY') last_start_dt,
       last_run_duration,
       To_char(next_run_date, 'DD-MON-YYYY')   next_run_date,
       schedule_limit,
       max_run_duration,
       logging_level,
       stop_on_window_close,
       instance_stickiness,
       raise_events,
       system,
       job_weight,
       nls_env,
       source,
       destination,
       comments,
       flags
FROM   dba_scheduler_jobs
WHERE  job_name LIKE '%IT%'  

 1* select object_type, count(*) from dba_objects group by object_type order by 1
SQL> /

OBJECT_TYPE	      COUNT(*)
------------------- ----------
CLUSTER 		    10
CONSUMER GROUP		    25
CONTEXT 		     7
DATABASE LINK		     2
DESTINATION		     2
DIMENSION		     5
DIRECTORY		    10
EDITION 		     1
EVALUATION CONTEXT	    15
FUNCTION		   313
INDEX			  3938
INDEX PARTITION 	   682
INDEXTYPE		     9
JAVA CLASS		 22920
JAVA DATA		   328
JAVA RESOURCE		   834
JAVA SOURCE		     2
JOB			    15
JOB CLASS		    13
LIBRARY 		   183
LOB			   924
LOB PARTITION		     1
MATERIALIZED VIEW	     3
OPERATOR		    55
PACKAGE 		  1316
PACKAGE BODY		  1254
PROCEDURE		   185
PROGRAM 		    19
QUEUE			    40
RESOURCE PLAN		    10
RULE			     1
RULE SET		    23
SCHEDULE		     3
SCHEDULER GROUP 	     4
SEQUENCE		   231
SYNONYM 		 27806
TABLE			  2982
TABLE PARTITION 	   531
TRIGGER 		   626
TYPE			  2824
TYPE BODY		   244
UNDEFINED		     9
VIEW			  5063
WINDOW			     9
XML SCHEMA		    52

45 rows selected.

SQL> select * from dba_scheduler_job;
select * from dba_scheduler_job
              *
ERROR at line 1:
ORA-00942: table or view does not exist

SQL>
SQL> select * from dba_scheduler_jobs;
ERROR:
ORA-01882: timezone region %s not found


no rows selected

col parameter format a40
col value format a40
select * from v$nls_parameters where parameter like '%TIME%' order by 1;
select sessiontimezone, dbtimezone from dual;
select * from v$version;

SQL> col parameter format a40
SQL> col value format a40
SQL> select * from v$nls_parameters where parameter like '%TIME%' order by 1;

PARAMETER
----------------------------------------
VALUE
----------------------------------------
NLS_TIMESTAMP_FORMAT
DD-MON-RR HH.MI.SSXFF AM

NLS_TIMESTAMP_TZ_FORMAT
DD-MON-RR HH.MI.SSXFF AM TZR

NLS_TIME_FORMAT
HH.MI.SSXFF AM


PARAMETER
----------------------------------------
VALUE
----------------------------------------
NLS_TIME_TZ_FORMAT
HH.MI.SSXFF AM TZR


SQL> select sessiontimezone, dbtimezone from dual;

SESSIONTIMEZONE
---------------------------------------------------------------------------
DBTIME
------
+05:30
-05:00


SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE    11.1.0.7.0      Production
TNS for HPUX: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production

$ oerr ORA 01882
01882, 00000, "timezone region %s not found"
// *Cause: The specified region name was not found.
// *Action: Please contact Oracle Customer Support.