-
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
-
UNIX operating System
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?
-
Re: UNIX operating System
[QUOTE][i]Originally posted by lesstjm [/i]
[B]Then run that script using the at command. [/B][/QUOTE]
Or, if you want the job run at specified time periods, use cron.
Both cron and at run in the background.
Jeff Hunter
-
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:
[url]http://otn.oracle.com/doc/oracle8i_816/server.816/a76956/jobq.htm[/url]
You need an account, but it's free.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|