#2 DBMS_JOB scheduling

[pabloj]

Another one ;-) the ability to list all dbms jobs scheduled
and to add/alter/delete jobs.

[Karel Miarka]

Logged In: YES
user_id=493337

I must admit that I don't know Oracle very deeply, all I
usually do with Oracle are create/alter/drop
tables/views/sequences and select/insert/update/delete on
table data operations. Till today I even didn't know that
DBMS_JOB exists.

So Ok, if I have some time and taste to play with that I can,
but I cannot promise anything.

[dialsm]

Logged In: YES
user_id=1010648

dbms_jobs is a standard oracle package that helps administer
this. You can issue something like:

exec dbms_jobs.remove(1)

in sqlplus to remove the job id "1". To view jobs, you can
query the data dictionary:

select * from dba_jobs

or

select * from all_jobs

or

select * from user_jobs

depending on access levels.

[dialsm]

Logged In: YES
user_id=1010648

clarification. I was writing in plural, however, the package is
just dbms_job (singular)

ie,
dbms_job.submit()
dbms_job.remove()
dbms_job.change()
dbms_job.what()

etc.