Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    33

    Unanswered: DBMS_JOBS- Every Half an Hour

    hi

    i need a script interval to run a job for every 30 minutes everyday.

    cud anyone help out..........

  2. #2
    Join Date
    Sep 2003
    Location
    Assen, Nederland
    Posts
    55
    You need? How about looking at the dbms_job and trying it out yourself.
    0.5/24=1/48, no?
    Hope that helped...
    Visit My Website : http://www.oraflame.com
    _____________________________
    Tarry Singh

    OCP DBA 8i
    Currently: SQL Server DBA 7,2000
    Oracle, PHP Programmer

  3. #3
    Join Date
    Sep 2003
    Posts
    33
    Tx Tarry

    Will this be okay?


    dbms_job.submit(123,
    'isEmailAlertPending;',
    trunc(sysdate)+18/24,
    'trunc(SYSDATE+0.5/24,''HH'')');
    commit;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •