Hello there,

I need your help getting a sqlserver agent job up and
running.

Background:
- We have a database that is fed syslog information. When
connections are made through the syslog, information such
as hostname, date, time is recorded and entered into the
database.
- These connections are happening continously throughout
the day
- We need to be able to have an operator notified when a
certain number of connections is reached. For example, if
there are 500 connections made in 30 minutes, we would
like for an email to be sent to a particular operator.

Where we are so far:
- I'm in the process of creating a job in the sql server
agent service.
- If i go to the job properties, then notifications tab;
and then try to send a test email to the nominated
operator, it displays the following error:

"Error 22022: SQLServerAgent Error: The SQLServerAgent
mail session is not running; check the mail
profileand/orthe SQLServerAgentservice startupaccount in
the SQLServerAgent properties dialog."

Hence the problem...

Ive tested the mail profile and it works fine. I've tried
so many other things that i just can't remember at the
moment.

Am i going about this task the wrong way? If yes, please
advise as to what the best way to go about this is. If
not, how can i get around this error? Help me! Please!

Cheers,
Von