automatic processes

I need to know if there is a way to program automatic processes. That is, processes that launch tehmselves instead of having someone run them periodically.

Thanks

If you are using the UNIX operating system you can write a shell script to run your oracle jobs. Then run that script using the at command.

If I run them with the at command they would be running in the background, right?

Quote:

---

Originally posted by lesstjm
Then run that script using the at command.

---

Or, if you want the job run at specified time periods, use cron.

Both cron and at run in the background.

Thanks a lot!!! I'll try that!

If you want to run PL/SQL code periodically or at a specific time or, use DBMS_JOB.
Check for more information:
http://otn.oracle.com/doc/oracle8i_8...76956/jobq.htm
You need an account, but it's free.