Email subscription

I have couple of reports on email subscription. These are exception reports
that get delivered if there are records in the report. The question is that
an empty report gets delivered if there are no records. Is there any way to
stop email delivery on a subscription when no data is returned in the report.
--
Thanks
RK BalajiCurrently the only way to do this is through data driven subscriptions. You
need to have the data driven subscription query return no rows if the report
will be empty.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"RK Balaji" <RKBalaji@.discussions.microsoft.com> wrote in message
news:B0621348-831B-40D6-979B-4EB867984B0E@.microsoft.com...
>I have couple of reports on email subscription. These are exception reports
> that get delivered if there are records in the report. The question is
> that
> an empty report gets delivered if there are no records. Is there any way
> to
> stop email delivery on a subscription when no data is returned in the
> report.
> --
> Thanks
> RK Balaji

E-mail notification issues

I just set up an SMTP email account though the Management Studio à Server à Database Mail.The test email was successfully delivered to my mail box.

Now I’m trying to test the notifications.I created an Operator with my email address, and my test job is set to email the operator when the job completes using the email account above.

However I am not receiving any emails upon the completion of the job.When I go to notification history under the Operator, there is none.

What am I missing?

Thanks a lot for your help!

The answer is simple - reboot SQL Server Agent|||

I am connecting remotely to my server. Is there a way to test an email account or do I need to log in locally? I have set up an operator and am able to set a notification on my job, but it doesn't send the email. I'm not able to see the same path you used above. Any ideas?

|||

LoveDanger wrote:

I just set up an SMTP email account though the Management Studio à Server à Database Mail. The test email was successfully delivered to my mail box.

I think I have a similar scenario here (see also SQL Server Agent Mail (SQL Server 2005 Database E-Mail) in this forum).

LoveDanger wrote:

Now I’m trying to test the notifications. I created an Operator with my email address, and my test job is set to email the operator when the job completes using the email account above.

It looks like I forgot to create an operator. What exactly is this and where can I create this? I'm using the german version of SQL Server and can't translate the term operator to a SQL Server related term i know.

Thanx in advance and best regards,
Gerald

|||I have found it now in the German version, defined an operator and now everything is working fine :-)

@.LoveDanger
Try to do the trouble shooting for database mail, i.e. have a look in the associated tables, e.g.

SELECT * FROM msdb.dbo.sysmail_allitems
SELECT * FROM msdb.dbo.sysmail_sentitems
SELECT * FROM msdb.dbo.sysmail_faileditems
SELECT * FROM msdb.dbo.sysmail_event_log

regards,
Gerald

|||

I couldn't find that because I'm connecting to an earlier version of SQL Server with a newer version.

E-mail notification issues

I just set up an SMTP email account though the Management Studio à Server à Database Mail.The test email was successfully delivered to my mail box.

Now I’m trying to test the notifications.I created an Operator with my email address, and my test job is set to email the operator when the job completes using the email account above.

However I am not receiving any emails upon the completion of the job.When I go to notification history under the Operator, there is none.

What am I missing?

Thanks a lot for your help!

The answer is simple - reboot SQL Server Agent

EMail is blocked from subscriptions

When subscribing to a report, with email notification, the report runs on
schedule but the email is not delivered...the error "The transport error code
was 0x800ccc15. The server response was not available..." is displayed. We
have excluded DatabaseMail90.exe and ReportingServicesService.exe from the
option
â'Prevent mass mailing worms from sending mailâ' in the Mcafee virusscanner,
but it still gets blocked. I'm guessing we still haven't identified the
correct process. Any help would be appreciated.Look at the permissions of the "Unattended Execution" user in the "Report
Server Configuraiton" manager.
It needs more rights.
"Alchemist" <Alchemist@.discussions.microsoft.com> wrote in message
news:7FA15047-F258-47AF-A964-673A9467FC40@.microsoft.com...
> When subscribing to a report, with email notification, the report runs on
> schedule but the email is not delivered...the error "The transport error
> code
> was 0x800ccc15. The server response was not available..." is displayed.
> We
> have excluded DatabaseMail90.exe and ReportingServicesService.exe from the
> option
> 'Prevent mass mailing worms from sending mail' in the Mcafee virusscanner,
> but it still gets blocked. I'm guessing we still haven't identified the
> correct process. Any help would be appreciated.
>|||We didn't find an "Unattended Execution" parameter, but there is an
"Execution Account" parameter that appeared to be what you meant...but it
didn't work. We still get the "Failure sending mail: The message could not
be sent to the SMTP server. The transport error code was 0x800ccc15. The
server response was not available" error message. Seams the DB access is not
the issue, but getting to the SMTP server is. Is there something else we
could be missing'

Email delivery, rendering format problem

Hi,

Im trying to set up so the report gets delivered to specified email addresses with the rendering format set to Web Archive.

The problem is, it wont deliver the background of the report. We really need the background to be yellow (company color) i have tried with both the backgroundcolor setting and backgroundimage setting with repeat =true, but it just delivers the email as transparent(white) background.

Anyone know how to solve this?

regards,
xenojust seem like it is impossible. For those with similiar problem in the future, here is the work-around that i used:
Put a rectangle on your form that stretches 100% with and height of the form and put all objects within it. Make sure it will be resizable to fit.

I dont like it at all, but hey...cant waste too much time on these things when the clock is ticking.
.xeno

Email delivery failure

Has anyone had issues with emails being delivered? The job runs successfully,
but the email does not get delivered. It seems to be related to the Reporting
Services server and not the email server. The reason I believe this is that,
after I reboot the Reporting Services server, the emails are successful. I
haven't been able to determine what causes the blockage on that server.Correction: Has anyone had issues with emails "not" being delievered?
"Rand" wrote:
> Has anyone had issues with emails being delivered? The job runs successfully,
> but the email does not get delivered. It seems to be related to the Reporting
> Services server and not the email server. The reason I believe this is that,
> after I reboot the Reporting Services server, the emails are successful. I
> haven't been able to determine what causes the blockage on that server.|||I am having the same exact issue. Any luck? Can you provide input on how you
resolved your issue, if you did?
"Rand" wrote:
> Correction: Has anyone had issues with emails "not" being delievered?
> "Rand" wrote:
> > Has anyone had issues with emails being delivered? The job runs successfully,
> > but the email does not get delivered. It seems to be related to the Reporting
> > Services server and not the email server. The reason I believe this is that,
> > after I reboot the Reporting Services server, the emails are successful. I
> > haven't been able to determine what causes the blockage on that server.

Email Attachment Corruption

I have a subscription to a report that delivers an Excel attachment. When delivered to my outlook mailbox, no problems. Same report attachment delivered to my hotmail account is corrupted. Results are the same with the CSV option.
Is this related to the problem with lotus mail servers?What is the corruption? The lotus issue is that the emails have a 0 byte
attachment.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stuart Finley" <StuartFinley@.discussions.microsoft.com> wrote in message
news:71507D7C-7594-4467-B42A-715E4359B306@.microsoft.com...
>I have a subscription to a report that delivers an Excel attachment. When
>delivered to my outlook mailbox, no problems. Same report attachment
>delivered to my hotmail account is corrupted. Results are the same with the
>CSV option.
> Is this related to the problem with lotus mail servers?|||The attachments are garbled -- their size doesn't appear to change.
So far this behavior occurs only when I send the report to a Hotmail account. A lycos internet account is working.
"Lukasz Pawlowski [MSFT]" wrote:
> What is the corruption? The lotus issue is that the emails have a 0 byte
> attachment.
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Stuart Finley" <StuartFinley@.discussions.microsoft.com> wrote in message
> news:71507D7C-7594-4467-B42A-715E4359B306@.microsoft.com...
> >I have a subscription to a report that delivers an Excel attachment. When
> >delivered to my outlook mailbox, no problems. Same report attachment
> >delivered to my hotmail account is corrupted. Results are the same with the
> >CSV option.
> >
> > Is this related to the problem with lotus mail servers?
>
>|||This is probably related to the same issue. KB Article 872774 will discuss
this issue, although the KB doesn't seem to be available yet. You will need
to contact PSS to get the fix for this issue.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stuart Finley" <StuartFinley@.discussions.microsoft.com> wrote in message
news:B3B6E32C-6878-44D2-8AE9-9C451C727E75@.microsoft.com...
> The attachments are garbled -- their size doesn't appear to change.
> So far this behavior occurs only when I send the report to a Hotmail
account. A lycos internet account is working.
> "Lukasz Pawlowski [MSFT]" wrote:
> > What is the corruption? The lotus issue is that the emails have a 0
byte
> > attachment.
> >
> > -Lukasz
> >
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Stuart Finley" <StuartFinley@.discussions.microsoft.com> wrote in
message
> > news:71507D7C-7594-4467-B42A-715E4359B306@.microsoft.com...
> > >I have a subscription to a report that delivers an Excel attachment.
When
> > >delivered to my outlook mailbox, no problems. Same report attachment
> > >delivered to my hotmail account is corrupted. Results are the same with
the
> > >CSV option.
> > >
> > > Is this related to the problem with lotus mail servers?
> >
> >
> >