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 processWouldn't it be better to find the process that is deleteing the iew(s) and stop it?

CreateReportHistorySnapshot

Is there a way to setup history snapshots to be deleted after a specified
timeframe (30 days) forexample? Does RS 2005 have an automated cleanup
process to delete these snapshots?Yes. From the Report Manager home page, select SITE SETTINGS. Here you can
specify how many days snapshot are kept before deleting.
"shassbel" wrote:
> Is there a way to setup history snapshots to be deleted after a specified
> timeframe (30 days) forexample? Does RS 2005 have an automated cleanup
> process to delete these snapshots?|||The only setting for report history that I see is to limit the number of
copies for report history. The number of days on that screen refers to
execution logs.
"kbright" wrote:
> Yes. From the Report Manager home page, select SITE SETTINGS. Here you can
> specify how many days snapshot are kept before deleting.
> "shassbel" wrote:
> > Is there a way to setup history snapshots to be deleted after a specified
> > timeframe (30 days) forexample? Does RS 2005 have an automated cleanup
> > process to delete these snapshots?