Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

msdb.dbo.sp_send_dbmail Not working with SQL JOB Expand / Collapse
Author
Message
Posted Thursday, September 2, 2010 1:37 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, February 7, 2011 10:00 PM
Points: 19, Visits: 66
Hi All,

i have a SP, which will do some update operations and send mail to respective users

to send mail i'm using msdb.dbo.sp_send_dbmail

when i execute this SP Query Analyzer it works fine and sends mail,

but when i incorporate this SP in SQL Agent as a nightly build process it's not working and doesn't sends mail

but executes successfully.

What's the issue

thanks in advance

Prakash.C
Post #979858
Posted Thursday, September 2, 2010 11:51 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, February 7, 2011 10:00 PM
Points: 19, Visits: 66
Hi all,

no one has encountered such a problem yet....?

Post #980043
Posted Monday, September 6, 2010 5:52 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 7:55 AM
Points: 359, Visits: 927
Can you fire the Job in day time and run a trace at the same time to see what's happening?
Post #981062
Posted Monday, September 6, 2010 6:46 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 3:43 AM
Points: 882, Visits: 4,144
have you configured the correct operator in notification tab of sql job?

----------
Ashish
Post #981089
Posted Monday, September 6, 2010 11:07 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:16 AM
Points: 2,840, Visits: 3,983
prakashdotc (9/2/2010)
when i incorporate this SP in SQL Agent as a nightly build process it's not working and doesn't sends mail
Are you using the correct profile/account name ? i am sure not


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #981312
Posted Monday, September 16, 2013 11:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 11:32 AM
Points: 1, Visits: 135
My DBMail stopped working on 2 production servers after I upgraded to SQL 2012 SP1. It doesn't work from the query window or from an SQL job. It does work on the 2 corresponding test servers!? Same service pack was applied to all 4. Any ideas?
Post #1495205
Posted Tuesday, September 17, 2013 7:27 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 2:00 PM
Points: 820, Visits: 2,130
This won't be helpful per se, but recently I have an extremely difficult time trying to get the dbmail to work. I'd followed all of the steps, and had no issues on all but one server, unfortunately a production one. I looked through all the posts, and tried an uncounted number of things. One evening, it simply started working. One day I expect it will stop working, and I will have no idea why. Just maddening!

Good luck.



Post #1495502
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse