Mail is not firing - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Mail is not firing

Author

Topic

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2008-06-24 : 16:46:57

I have a job that fires every 15 minutes. Job is working.
I looked in here
select * from msdb.dbo.sysmail_allitems
records are in here...

I looked in here and
select * from msdb.dbo.sysmail_log it says the database mail is
2008-06-24 14:46:10.997 DatabaseMail process is started
2008-06-24 14:56:13.453 DatabaseMail process is shutting down
Which it seems to do periodically ....through out the log

What starts up the process - to go run the email alerts.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-24 : 16:49:48

Did you setup Database mail recently?

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2008-06-24 : 17:17:15

No it has been working for a while then i noticed it was not sending out the emails ........

svicky9
Posting Yak Master

232 Posts

Posted - 2008-06-25 : 02:01:56

a . Look at the Sent Items of the Mail Box for the profile if you have access
b . Send a Test Message from the DB Mail
c . Trying sending an email using sp_send_dbmail to your email account

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2008-06-25 : 08:28:45

The email is going to myself - nothing in my sent box..
Test Email works goes through and emails myself.
Everything else works except when it is scheduled.

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2008-06-25 : 08:39:36

Seem to have a about 30 threads in activity windows for
DatabaseMail90 id
and msdb.dbo.sp_ProcessResponse

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-25 : 11:41:06

"Everything else works except when it is scheduled"

Sometimes Restarting SQL Server agent services will solve the issue.But make sure no jobs are running at that time.

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2008-06-25 : 14:42:09

If i run this EXECUTE dbo.sysmail_start_sp then all the emails start running.
Not sure i want to keep doing this ..though.

I restart the sql agent and see if this works..

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2008-06-25 : 22:13:29

Restarted agent seem to be working now. Thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-25 : 22:25:40

Welcome!!

maninder
Posting Yak Master

100 Posts

Posted - 2008-06-26 : 12:50:46

Some Tips:
--Database Mail relies on Service Broker for queuing e-mail messages
EXECUTE msdb.dbo.sysmail_help_queue_sp @queue_type = 'Mail'

--Check Broker Status
SELECT is_broker_enabled FROM sys.databases WHERE name = 'msdb'

--Check DB MAIL Status
EXECUTE msdb.dbo.sysmail_help_status_sp ;

--Start DB Mail
EXECUTE msdb.dbo.sysmail_start_sp ;

--Stop DB Mail
EXECUTE msdb.dbo.sysmail_stop_sp;

Maninder

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2008-06-26 : 13:02:11

quote:
Originally posted by sodeep

"Everything else works except when it is scheduled"

Sometimes Restarting SQL Server agent services will solve the issue.But make sure no jobs are running at that time.

Makes it sound like a security/permissions issue to me.

e4 d5 xd5 Nf6

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources