[dba-SQLServer]Transaction Log *Notification*

Haslett, Andrew andrew.haslett at ilc.gov.au
Wed Aug 20 22:58:46 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.


More information about the dba-SQLServer mailing list