Haslett, Andrew
andrew.haslett at ilc.gov.au
Wed Aug 20 22:48:56 CDT 2003
You need to have a MAPI client installed on the server. The way we did it, was to install Outlook on the server, create a profile in exchange and link it to the SQL Service (and SQL Agent) account (they are the same on our server). We may have even needed to restart the server for the settings to take effect. At minimum, we had to restart the SQL service. Cheers, Andrew -----Original Message----- From: Nicholson, Karen [mailto:knicholson at gpsx.net] Sent: Thursday, 21 August 2003 3:39 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer]Transaction Log *Notification* OK. I will. I did all the steps and got an error message and am clueless but happy. When I went to test the email in the Response tab, I get an error messaged 22022: SQL Server Agent Error. The SQLServerAgent mail session is not running; check the male profile and/or the SQLServerAgent service startup account in the SQLServerAgent Properties box. So, I do as they say. Service account is checked as system account. Male profile has nothing in it and nothing to select in the drop-down box. Any ideas? -----Original Message----- From: Francisco H Tapia [mailto:my.lists at verizon.net] Sent: Wednesday, August 20, 2003 12:52 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer]Transaction Log *Notification* Feel free to brainstorm any SQL related questions on the list... keep having fun :) -Francisco http://rcm.netfirms.com On Wednesday, August 20, 2003 9:29 AM [GMT-8], Nicholson, Karen <knicholson at gpsx.net> wrote: : Thank you. My head is spinning between learning VB, SQL Server, : Crystal Reports and the company culture and needs. It is the most : fun I have ever had but a bit overwhelming at times. : : -----Original Message----- : From: Francisco H Tapia [mailto:my.lists at verizon.net] : Sent: Wednesday, August 20, 2003 11:26 AM : To: dba-sqlserver at databaseadvisors.com : Subject: Re: [dba-SQLServer]Transaction Log *Notification* : : : It's called an Alert and you can have it do any number of things... : Sql Server Enterprise Manager : : Management > Sql Server Agent > Alerts : : Create a new alert : : In the General Tab... : Name : the name you want to give your alert : Type: Sql Server Performance condition alert (make sure to enable : this) Object: Sql Server:Databases : Counter: Percent Log Used : Instance: Your database Name : Alert if counter: Rises above : Value: 90 : : In the Response Tab... : add the operators who will receive the alert... here you can do a : numbe of trick things... on top of which you can execute a job, such : as a backup the log with truncate. The methods for alerting is : Email, Pager and Net Send, currently I only have net send enabled on : my server but would like to enable the page setting but have not : played w/ that option yet. : : simply add the users you want to have alerted and the method and : you're done... if you want to execute a procedure or whatever just : select the Execute Job and the name of the job you want to execute : when the condition (alert) is met... : : You can also enable how long to wait before another alert will be sent : again... I have mine set to 60% of log used and 0 minutes and 0 : seconds delay between responses... : : -Francisco : http://rcm.netfirms.com : : On Wednesday, August 20, 2003 7:27 AM [GMT-8], : Nicholson, Karen <knicholson at gpsx.net> wrote: : :: Does anyone know of a way that I can generate an email message to :: those in my group who oversee our database when the transaction log :: has reached 90% of its capacity? Thanks. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com IMPORTANT - PLEASE READ ******************** This email and any files transmitted with it are confidential and may contain information protected by law from disclosure. If you have received this message in error, please notify the sender immediately and delete this email from your system. No warranty is given that this email or files, if attached to this email, are free from computer viruses or other defects. They are provided on the basis the user assumes all responsibility for loss, damage or consequence resulting directly or indirectly from their use, whether caused by the negligence of the sender or not.