Database Jobs

[VishalN]

Hi All,

I have created two jobs in sys database as follows,
BEGIN
sys.dbms_scheduler.create_job(
job_name => 'JOB_FCDB_CHARGES',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN FCDBCHARGES; END;',
repeat_interval => 'FREQ=DAILY;BYHOUR=19',
job_class => 'DEFAULT_JOB_CLASS',
comments => 'Job to process Internet Banking Charges.',
auto_drop => FALSE,
enabled => FALSE);

sys.dbms_scheduler.set_attribute(
name => 'JOB_FCDB_CHARGES',
attribute => 'schedule_limit',
value => numtodsinterval(10, 'minute'));

sys.dbms_scheduler.set_attribute(
name => 'JOB_FCDB_CHARGES',
attribute => 'start_date',
value => to_timestamp_tz('2012-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'));
sys.dbms_scheduler.enable( 'JOB_FCDB_CHARGES' );
END;

It has been successfully created.

Even i am able to entries in
tables as follows,
1) select owner, object_name, object_type
from dba_objects where owner = 'SYS' and object_name like '%JOB_FCDB_CHARGES%';

2) SELECT * FROM all_scheduler_jobs
where job_name like '%JOB_FCDB_CHARGES%';

3) SELECT * FROM dba_scheduler_jobs
where job_name like '%JOB_FCDB_CHARGES%';

But, my problem is when i log in to PL/SQL developer why am i not able to see from PL/SQL developer editor. Under My Objects -> Jobs

Please, help me out!! Thanks in Advance.

 

[Marco Kalter]

Are you connected as SYS in PL/SQL Developer? The "My objects" filter will only show objects owned by the currently connected user.

 

[dgs!]

I can see programs I have created using dbms_scheduler.create_program, but I can not see the chain I have created using dbms_scheduler.create_chain.

Both of these objects are in my schema and are visible using
Select * from user_objects where object_type in('CHAIN','PROGRAM')

But the chain is not visible in the object browser witht e filter set to , All Objects.

 

[dgs!]

Oracle's SQL Developer has a nice graphical tool (that doesn't work very well).
Any plans to implement something like that here? It's helpful to see the steps/step rules layed out.