automatic processes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: automatic processes

  1. #1
    Join Date
    Jan 2001
    Posts
    9

    Question

    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

  2. #2
    Join Date
    Jan 2001
    Posts
    515

    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.

  3. #3
    Join Date
    Jan 2001
    Posts
    9
    If I run them with the at command they would be running in the background, right?

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Jan 2001
    Posts
    9
    Thanks a lot!!! I'll try that!

  6. #6
    Join Date
    Jul 2000
    Posts
    296
    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
  •  


Click Here to Expand Forum to Full Width