Need help in SSRS Report

Question

Need help in SSRS Report

ramana3327

SSCoach

Points: 19722
More actions
September 10, 2014 at 11:20 am

#296085

Hi,
I am getting the email of SSRS report everyday twice. I need to find why it is coming twice. Under the subscriptions the schedule time is only once. That means is that processing twice?
Any suggestions please

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Shawn Melton SSC-Insane Points: 24685 More actions · Answer 1

The subscriptions are run by a SQL Agent job running, it tells the SSRS service that "hey you need to run this report". I would check to see if the associated SQL Agent job is being run twice for some reason, could have been modified.

This MSSQLTips.com article [/url]can help you identify the specific job.

Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton

ramana3327 SSCoach Points: 19722 More actions · Answer 2

Thanks Shawn

Last week we got mail only one time. This problem just started 3 days back. Here when I see the Job, it has 2 schedules with 1hr difference. Also the scheduled start dates are different. How can we find out that problem?

Shawn Melton SSC-Insane Points: 24685 More actions · Answer 3

Based on that it is likely someone modified the job from SQL Server Agent. Since these jobs are not supposed to be modified from that side I would suggest deleting the schedule from SSRS. Then make sure SSRS deleted the scheduled job from SQL Server Agent.

Then you can just recreate it. In prevention of it happening again you should find out who has access to the SQL Server instance to make changes to the Agent jobs.

Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton

ramana3327 SSCoach Points: 19722 More actions · Answer 4

Hi Shawn,

use msdb;

GO

select name, date_modified, enabled ,*from sysjobs where name='JobName'

when I use that query it is showing that the data_modified was last year. That means there is no recent modification for the job.

Any further help

Shawn Melton SSC-Insane Points: 24685 More actions · Answer 5

ramana3327 (9/10/2014)
Hi Shawn,
use msdb;
GO
select name, date_modified, enabled ,*from sysjobs where name='JobName'
when I use that query it is showing that the data_modified was last year. That means there is no recent modification for the job.
Any further help

My previous statement still holds to what I would do. I do not know when that date column is actually updated in the background. Your job has two scheduled when was the schedule created? Either way if the schedule is not running as intended I would delete it and recreate it.

Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton

ramana3327 SSCoach Points: 19722 More actions · Answer 6

Hi Shawn,

I go and check the reportserver executionlog.

For the same reportID

I can see different times from 2 days. Can you check the below attachment pls.

i.e. I am thinking it is processing twice

Shawn Melton SSC-Insane Points: 24685 More actions · Answer 7

You already determined that the associated SQL Agent job for this scheduled report contains two schedules within the configuration of the Job. If it does indeed have that then that is the reason it is running twice. If that is a problem, and the SSRS schedule setup only shows one schedule then something or someone has modified the SQL Agent Job schedule.

Unless you want to keep getting two emails either delete the additional schedule in the SQL Agent job or delete the schedule from SSRS and recreate it, this will cause a new SQL Agent job to be created.

Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton

ramana3327 SSCoach Points: 19722 More actions · Answer 8

Thanks Shawn.

So you mean, if I reschedule the the subscription automatically it delete the previous sql job and creates the new job.

Rescheduling the subscription will solve the issue

ramana3327 SSCoach Points: 19722 More actions · Answer 9

Hi Shawn,

Sorry I saw another Job schedule but for that report subscription job scheduled is only one time. i.e. job is running only one time. But how if we see the report server log, we can clearly say that report is processing twice.

How to solve this kind of problems. We need that report for that only, we can't change the report subscription time here.

Any further help is appreciated