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 processWouldn't it be better to find the process that is deleteing the iew(s) and stop it?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment