Solved

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

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

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…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

762 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