Notify Script running status
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Notify Script running status

  1. #1
    Join Date
    Oct 2000
    Posts
    250

    Notify Script running status

    Hello all,
    Does anyone configure the database so that it can automatically notify status of the job to the administrator ? Inside the Script, there are many sub sql script. If any of the sub task is fail, I need to notify the administrator.

    What is the best tool to accomplish this task ? What are the minimum software requirement needed ?

    Your advice is very much appreciated.

    Regards,
    ckwan

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    if your batch job is PL/SQL you can use dbms_application_info to monitor the process

  3. #3
    Join Date
    Oct 2000
    Posts
    250
    hi,
    I managed to send mail from Oracle database but the problem facing now is the mail only can send to those internal user using the same domain name. When I send to external user like XXX@hotmail.com I will get the error message...

    ORA-29279: SMTP permanent error: 550 not local host hotmail.com, not a gateway
    ORA-06512: at "SYS.UTL_SMTP", line 17
    ORA-06512: at "SYS.UTL_SMTP", line 98
    ORA-06512: at "SYS.UTL_SMTP", line 240
    ORA-06512: at line 14

    Does anyone encounter same error like the above ?

    Thanks

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    What it basically menas is that your smpt server does not know how to send mail to the gateway to route the mail to the domain hotmail.You need to tell your smtp server to relay your mail to the gateway...

    You can try this test go to to your mail server and try sending a mail to xxx@hotmail.com you would see that your mail isnt delivered.So you need to tell your mail server about your mail gateway..ask your sysadmin to do that ;-D

    regards
    Hrishy

  5. #5
    Join Date
    Oct 2000
    Posts
    250
    Thanks for the information.

Posting Permissions

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



Click Here to Expand Forum to Full Width