DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to Alert me on exceptions

  1. 02-12-2001, 11:19 AM #1
    trogen
    trogen is offline Junior Member
    Join Date
    Jul 2000
    Posts
    70
    Im running an sql script on Linux at regular intervals through CRONTAB.
    How can I have the DBA alerted (via email or any other means) incase a unique constraint or any other exception occurs?
    Thanks.
    Reply With Quote Reply With Quote
  2. 02-12-2001, 11:52 AM #2
    akkerend's Avatar
    akkerend
    akkerend is offline Senior Member
    Join Date
    Jul 2000
    Posts
    296
    If database is 8.1.6 you can use UTL_SMTP to send DBA mail from exception handler.
    Reply With Quote Reply With Quote
  3. 02-12-2001, 11:55 AM #3
    trogen
    trogen is offline Junior Member
    Join Date
    Jul 2000
    Posts
    70
    Could you explain with an example on how to do it please?
    Thanks.
    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

Click Here to Expand Forum to Full Width