July 8, 2003 at 11:38 pm
Hi there,
I'm a rookie at Microsoft SQL and 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...
I've made sure the mail profile is the same as the machine login, im using a corporate or workgroup for outlook - i pretty much followed all the steps i found on the Microsoft Knowledge Base.
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,
vonnie
July 11, 2003 at 8:00 am
This was removed by the editor as SPAM
July 11, 2003 at 8:51 am
Vonnie,
This can happen if SqlServerAgent is not logged as the same account as the MSSQLserver. Check your Services on the server. Right click on these services and check the properties for the Log On account.
All the best,
Dale
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
July 14, 2003 at 12:25 am
Hi Dale,
I took your suggestion and it worked beautifully - your a machine!
Cheers,
vonnie
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply