Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2005-10-19 : 05:39:39
|
ashish writes "Dear Sir,I have to set up the exception alert in sql server2000 so that at the time of following circumstances we can be having the knowledge.So kindly tell me how to set this alertsEXCEPTION ALERTS :Requirement is if any of the following points occur we get the exception alert Points are as follows:1) Transaction Log before going to 900m.b2) After Process get block exception should give alert3) after 70 % CPU USUAGE gives alerts 4) If any queries taking more then 3000 milisec it should give the exception.5) If database backup fail then alert.SECOND PART QUESTION If iam generating alert then it should go through email to the person email account at that moment of time for that I have gone through ur article but could n't get as my main problem is i dont have microsoft exchange server and out look on the main database server and we are using jmail 3 party component in our mail or if u have any simple method of sql mail configuration please tell me how to Configure the mail in detail ASAP As its very urgent.Thanks &BestRegards,Ashish RewatkarSQL-SERVER DBA,CYBERLOG INTERNATIONAL PTE LTD,SINGAPORE" |
|
|
|
|