Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2006-11-10
4
Medium Priority
?
222 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 2000 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

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

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

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
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.
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses

916 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