Results 1 to 9 of 9
  1. #1
    Join Date
    Jun 2012
    Posts
    5

    Post Unanswered: Scheduling job in windows oracle

    Hi,

    am new to window oracle environment.I want to schdule a job in windows oracle which has to run SQL script weekly and send output via email.Appreciate your help in advance.

    Thank you
    Manjula

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    use DBMS_SCHEDULER to schedule the task

    Oracle Database Search Results: dbms_scheduler
    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.

  3. #3
    Join Date
    Jun 2012
    Posts
    5
    Hi,

    Thanks for your reply.How do we send the output of the script as an email using dbms_scheduler? Please suggest.

    Thanks
    Mnajula

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >How do we send the output of the script as an email using dbms_scheduler?
    "script" implies OS dependent code & you decided not to share with us involving OS name or version
    or even Oracle version (to 4 decimal places)

    Let me google that for you
    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.

  5. #5
    Join Date
    Jun 2012
    Posts
    5
    Hi,

    OS is Microsoft windows 2003 and oracle version is 10.2.0.1

    Thanks

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    unmodified Windows 2003 has no capability to send emails from script
    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.

  7. #7
    Join Date
    Jun 2012
    Posts
    5
    Hi,

    is there any option that we send an email in windows 2003 in oracle?

    Thanks

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >is there any option that we send an email in windows 2003 in oracle?
    UTL_MAIL
    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.

  9. #9
    Join Date
    Jun 2012
    Posts
    5
    Thanks for your response

Posting Permissions

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