stevewes (9/23/2013)
yeah this is a great help many thanks!!!next step is to I suppose create a Job with the SQL query in as a step the next step is how do I then if it reports greater than 90 then send an alert do I need an IF statement ??
I am not sure that I would use a sql job for this. How often will this job need to run? I guess the answer to that is how quickly do you need the notification to be sent? If it is once a day then a job would be fine but if you need the notification real time then a job is probably not the best choice. For real time notification a trigger might be a better choice.
Either way the sql would need to have an EXISTS.
IF EXISTS(The query that determines if there are rows > 90)
SendNotificationHere
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/