Viewing 4 posts - 1 through 5 (of 5 total)
It is the cause of the synatx error but email is still not being sent, in fact something as simple as this does not print anything:
ALTER PROCEDURE [dbo].[P_SENDEMAILNOTIFICATION]
@Days INT...
May 12, 2011 at 11:50 am
Welsh Corgi (5/12/2011)
Where exactly are you putting it? What line?You Can't get the value of @@Error?
Regards,
Welsh
like so:
ALTER PROCEDURE [dbo].[P_SENDEMAILNOTIFICATION]
@Days INT = 0
AS
BEGIN
DECLARE @EmailId NVARCHAR(1000)
SELECT
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Profile_Admin' ,...
May 12, 2011 at 11:35 am
Lowell (5/12/2011)
does this return results/an explanation for unsent mail/failed mail?
SELECT
err.[description],
fail.*
FROM [msdb].[dbo].[sysmail_event_log] err
inner join [msdb].[dbo].[sysmail_faileditems] fail
ON err.mailitem_id = fail.mailitem_id
This returns...
May 12, 2011 at 11:17 am
Viewing 4 posts - 1 through 5 (of 5 total)