Solved

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

Posted on 2006-11-10
4
214 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
  • 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

706 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now