Can anyone explain why the following schedule for a timed subscription ran on the first of February

Question

Can anyone explain why the following schedule for a timed subscription ran on the first of February

Resender

SSCertifiable

Points: 7443
More actions
February 2, 2015 at 3:57 am

#297304

Hello all,simple question,which I might facepalm over
I have the following schedule
Now this should only run on the first of January of each year,which it did yet it did
also run on the first of February,anyone know what I did wrong.
(you can ignore the begin running this schedule date,I changed that before taking the screen shot)

Viewing 5 posts - 1 through 4 (of 4 total)

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

doug.brown SSCertifiable Points: 5607 More actions · Answer 1

Are you sure that's the only subscription for this report? Like you, I can't see any reason that schedule would run on Feb 1.

Resender SSCertifiable Points: 7443 More actions · Answer 2

Yes I'm 100% sure that's the only subscription on this report

Gazareth One Orange Chip Points: 27737 More actions · Answer 3

Bear in mind you'll only be able to see your own subscriptions on that report, those created by other logins won't show.

Edit: I'm talking rubbish if you're looking in the report's own subscriptions page.

This might help you identify what's running it:

USE ReportServer

GO

SELECT c.Name AS Report, c.Path, s.Name AS ScheduleName, sub.Description AS ScheduleDescription, sub.LastRunTime

FROM dbo.Catalog c

INNER JOIN dbo.ReportSchedule rs ON rs.ReportID = c.ItemID

INNER JOIN dbo.Schedule s ON s.ScheduleID = rs.ScheduleID

INNER JOIN dbo.Subscriptions sub ON sub.SubscriptionID = rs.SubscriptionID

WHERE c.Name = 'Report Name'

Resender SSCertifiable Points: 7443 More actions · Answer 4

Gazareth (2/4/2015)
Bear in mind you'll only be able to see your own subscriptions on that report, those created by other logins won't show.
Edit: I'm talking rubbish if you're looking in the report's own subscriptions page.
This might help you identify what's running it:
USE ReportServer
GO
SELECT c.Name AS Report, c.Path, s.Name AS ScheduleName, sub.Description AS ScheduleDescription, sub.LastRunTime
FROM dbo.Catalog c
INNER JOIN dbo.ReportSchedule rs ON rs.ReportID = c.ItemID
INNER JOIN dbo.Schedule s ON s.ScheduleID = rs.ScheduleID
INNER JOIN dbo.Subscriptions sub ON sub.SubscriptionID = rs.SubscriptionID
WHERE c.Name = 'Report Name'

I'm looking via the manage subscriptions,since I don't have any subscriptions on that report (I only created the subscription)

I've executed that code,see the result below (sensitive info has been blanked out), I've included the history as well (or lack there off)