Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    5

    Unanswered: DBMS_Job & SQL Loader...

    Hi

    Could you anybody tell me or point me to any link/article that explains using an example,
    how to Sched a Job in Oracle and How to use SQL Loader.

    We have Ora 8i Enterprise. I am able to see SQLLDR.exe
    But no GUI for it.

    Please help

    Thanks.

  2. #2
    Join Date
    Jan 2003
    Location
    China
    Posts
    38

    For the JOB

    First,create a procedure to realize what you want to do.
    Then,create a job to call the procedure,you can use this to create the job: dbms_job.submit(job,what,next_date,interval)
    Fan Yi

  3. #3
    Join Date
    Jul 2004
    Posts
    5
    Create Procedure Sp_del_emp_job ()
    As

    Begin

    Delete Emp;
    Commit;


    End;

    This is the procedure. I want this to run every day at 3am.

Posting Permissions

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