May 21, 2009 at 8:37 pm
after running this is i got Command(s) completed successfully.but the recipient did not receive any email, below is my query.
EXECUTE master.dbo.xp_sendmail
@recipients = 'my_email'
@subject = 'Morning Report',
@message = 'Look at this data:',
@query = 'EXEC MyIssCount ''kay''',
@attach_results = 'true',
@no_output = 'true',
@width = 300
This is giving me a hard time, can anyone help, thanks
May 22, 2009 at 11:37 am
Is SQL Mail started? Do you have a MAPI Profile setup for the SQL Server service account?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 24, 2009 at 2:12 pm
Hi,
MAPI is well configured. I think i find a solution though, it worked after I'd added @dbuse and specified my queries's target db.
Regards.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply