SQL2008 - emailed reports

Hi Beau.

We had the same issue when we went to SQL 2008.

We ended up finding a few settings that needed to be checked.  You do need DB Mail and that the profile is setup in the T_DEFAULTS table. (user name and email server)

Stored procedures tended to be the issue at our site.

We don’t think that the emails are being sent to DB Mail, hence no log details about them.  Something is failing before the SQLCMD calling the sp_send_dbmail stored procedure. (Sorry Beau, geek talk!)

So whatever error is coming through the sql command, it’s not being returned (captured) by the stored procedure results.

The call to the sql command is failing to track the error and return to the stored procedure (result). Nothing ends up in DB mail for some reason.

Hope this helps you.

Anna Duric
System Application Administrator, Ticketing & CRM
the Arts Centre

T + 61 3 9281 8464
F + 61 3 9281 8282
M   0419 928 184
E   anna-maria.duric@theartscentre.com.au
W  http://www.theartscentre.com.au

Dear Technical People,

Ever since our upgrade to SQL2008, we have been experiencing issues with scheduled reports being emailed. 

All scheduled reports are running (as they appear in the report viewer), but certain ones are not being emailed (and I'm finding it tricky to work out what is causing the email not to go through).

Has anyone else experienced any issues with the email of scheduled reports since upgrading to SQL2008?  Would love to hear from you!

Beau

{Melbourne Recital Centre}

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Hi Beau.

We had the same issue when we went to SQL 2008.

We ended up finding a few settings that needed to be checked.  You do need DB Mail and that the profile is setup in the T_DEFAULTS table. (user name and email server)

Stored procedures tended to be the issue at our site.

We don’t think that the emails are being sent to DB Mail, hence no log details about them.  Something is failing before the SQLCMD calling the sp_send_dbmail stored procedure. (Sorry Beau, geek talk!)

So whatever error is coming through the sql command, it’s not being returned (captured) by the stored procedure results.

The call to the sql command is failing to track the error and return to the stored procedure (result). Nothing ends up in DB mail for some reason.

Hope this helps you.

Anna Duric
System Application Administrator, Ticketing & CRM
the Arts Centre

T + 61 3 9281 8464
F + 61 3 9281 8282
M   0419 928 184
E   anna-maria.duric@theartscentre.com.au
W  http://www.theartscentre.com.au

Dear Technical People,

Ever since our upgrade to SQL2008, we have been experiencing issues with scheduled reports being emailed. 

All scheduled reports are running (as they appear in the report viewer), but certain ones are not being emailed (and I'm finding it tricky to work out what is causing the email not to go through).

Has anyone else experienced any issues with the email of scheduled reports since upgrading to SQL2008?  Would love to hear from you!

Beau

{Melbourne Recital Centre}

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!