Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    London
    Posts
    341

    Exclamation Unanswered: Using Scheduler to Run 3 scripts

    I'm new to Oracle DB to begin with, but for the life of me I cannot work out how to use Oracle's scheduler.

    I need to run a report every hour for the next week for a project.

    I have written the 3 scripts that spool the results to csv files.

    If I reference these 3 scripts using the below, the scripts run and the output files are generated


    @H:\Christyxo\FinalOutputP1.sql
    @H:\Christyxo\FinalOutputP2.sql
    @H:\Christyxo\FinalOutputP3.sql


    I need to use the scheduler to issue those 3 lines but I can't work out how!

    Can anyone help? I'm open to any suggestions!

    Christy
    Last edited by christyxo; 03-30-15 at 08:20.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    consider to actually Read The Fine Manual

    http://docs.oracle.com/database/121/ARPLS/d_sched.htm
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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