Issuing a background execute procedure command
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Issuing a background execute procedure command

  1. #1
    Join Date
    May 2001
    Posts
    55

    Question Issuing a background execute procedure command

    Hi Folks,

    In Unix, I can start a background process by using nohup and &.

    In Sql Plus I have a procedure which will take 2-3 days to run.

    I wish to know if there is a safe way of issuing the execute procedure in the background and then coming out of my Sql Plus session, switch off my pc and go home and then check if this procedure has completed after 2-3 days, like over the weekend? If so how do I do this?

    (I do not have Unix here so I cannot issue the background process, I have Win 95 running on my computer and the database is on a server running Unix)

    Any help will be much appreciated.

    Thanks in advance.
    A farmer learns more from a bad harvest than a good one

  2. #2
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    Look for DBMS_JOB.
    Agasimani
    OCP(10g/9i/8i/8)

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Hi

    try using DBMS_JOB package :-)

    Regards
    Amar

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