Home » RDBMS Server » Server Administration » Re: JOBS
Re: JOBS [message #374780] Mon, 02 July 2001 06:36
Lars Sjöström
Messages: 24
Registered: June 2001
Junior Member
You schedule jobs using DBMS_JOB.SUBMIT, like
EXECUTE DBMS_JOB.SUBMIT(a_job, a_procedure,run_date,NULL, FALSE)

setting a_procedure in a queue. If it is in the queue you can study using SELECT * FROM USER_JOBS.

A very good book on the subject is Oracle BUilt-in packages by Steven Feuerstein.

Report message to a moderator

Previous Topic: PLEASE HELP ME!!!!!!
Next Topic: Re: Like command Syntax
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 06 07:32:49 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.