Solved

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

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

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

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

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.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

617 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