Solved

subscription is sending dupe emails/dupe sql agent job(s)

Posted on 2006-11-10
4
219 Views
Last Modified: 2006-11-18
I made a modification to one of my reports recently (sql/rs v2K, vs .net 2003)
i just added 3 more subscriptions to it...so, it is to run 4 times daily, issuing an email each time.  
it just now ran today's run #1, and it sent two emails....so, i go in there and i find 4 new sql agent jobs.  
so, now there's eight jobs for the 4 subscriptions.  obviously, i only want/need four.  i've blown the extras out,
but, why would this happen?  i'm concerned about today's next 3 runs.
0
Comment
Question by:dbaSQL
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 17

Author Comment

by:dbaSQL
ID: 17916100
this is very important.  suddenly i need to similarly revise another report.  very simple, i need four emails throughout the day, so i need four subscriptons.  ONLY four.  does anybody know why the extras are created?  there are only four listed in report manager, subscriptions
0
 
LVL 17

Author Comment

by:dbaSQL
ID: 17916918
as i said, i'd created additional subscriptions for an existing report.  they've all run now --- only the first one sends 2 reports.  the rest only send the one expected email.  any thoughts at all?
0
 
LVL 16

Accepted Solution

by:
Hillwaaa earned 500 total points
ID: 17918878
Hi dbaSQL,

I'm note sure what could cause this - can you have a look in your Subscriptions table - just check that there are now just the 4 subscriptions for this report.  Also, double check that the schedule for the first report does not still have an extra option in it (since it used to send of 4 emails - you might have left an extra one on?).

Failing that - given that the three new ones all work ok - you might just want to delete the first one and re-create it.

Cheers!
0
 
LVL 17

Author Comment

by:dbaSQL
ID: 17921151
there are only 13 in there, that's exactly what i'd expect
i think i may delete it and create another, though
this has happened 3 times now, i just don't know what it is
thank you, hillwaaa, i will go ahead and close this
thanks for your input
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Multi-Parameter Report SQL 2008 2 92
CRM 2011 RDL Report - Print field up to a special character 6 91
How to create an interactive data pie chart 4 143
Montis monitoring 3 35
1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question