Manual Job Creations in sys.job$
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Manual Job Creations in sys.job$

  1. #1
    Join Date
    Nov 2001
    Location
    Birmingham, AL
    Posts
    2

    Question

    I want to know if it's possible to manually insert (create) new jobs from an insert statement directly into the sys.job$ table. I was able to do the insert, and the process appears to run, but it doesn't do anything, it doesn't really run ... is there another table that needs to be populated when creating a new job manually like that? What all must I keep in mind when doing something like this?

    Here's a sample of one I tried to do ...

    INSERT into sys.job$
    (job, lowner, powner, cowner, next_date, total, interval#, flag, what)
    VALUES
    (226, 'SYSTEM', 'SYSTEM', 'SYSTEM', to_date('19-NOV-2001 10:30:00', 'DD-MON-YYYY HH:MI:SS'), 0, 'NULL', 0, 'project.psvwc_populate;')

    Any assistance or documentation on this would be greatly appreciated.

  2. #2
    Join Date
    Sep 2001
    Location
    Dallas, TX
    Posts
    27
    Hi John,

    I think is not a practical way to setup jobs using Direct Insert int sys$ table. In my opinion one should be using DBMS_JOB package. The user can be given execute privilege on the same.

    BK.

  3. #3
    Join Date
    Nov 2001
    Location
    Birmingham, AL
    Posts
    2
    I thought of using that ... I'm actually trying to create a job scheduling program on a web browser with Active Server Pages ... can I call a database package like that with an ASP SQL call? Anybody know?

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