Results 1 to 2 of 2

Thread: creating alerts

  1. #1
    Join Date
    Feb 2003

    Unanswered: creating alerts

    I want to create an alert that for each time a sql view is deleted from the server alerts an operator and runs a sql query to recreate

    I have the code for recreating the view and this can be manually invoked and need some help in automating this other than create a job to run at scheduled intervals as this is only needs executed when treh views have been deleted

    **views are deleted by a rogue application process

  2. #2
    Join Date
    Feb 2002
    Houston, TX
    Wouldn't it be better to find the process that is deleteing the iew(s) and stop it?
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

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