Results 1 to 2 of 2

Thread: pl/sql dbms_scheduler.create_job

  1. 06-08-2010, 07:54 PM #1
    ecka00
    ecka00 is offline Registered User
    Join Date
    May 2005
    Posts
    111

    pl/sql dbms_scheduler.create_job

    I want to schedule a pl/sql script (@4portalLoad.sql) to run everyday at noon. Any ideas?
    Reply With Quote Reply With Quote
  2. 06-08-2010, 08:49 PM #2
    ecka00
    ecka00 is offline Registered User
    Join Date
    May 2005
    Posts
    111

    is this close?

    BEGIN
    DBMS_SCHEDULER.create_job (
    job_name => 'phsPortalLoad',
    job_type => 'PLSQL_BLOCK',
    job_action => '@4portalLoad.sql',
    start_date => '06/08/2010 10:00 PM',
    repeat_interval => 'FREQ=DAILY' ,
    enabled => TRUE,
    auto_drop => FALSE);
    END;
    /
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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