Hi, I'm having some problems with email subscriptions.
I've set up the subscription and schedule time but the schedule just doesn't
seem to run. It's reporting no errors, there's nothing in the log and the
subscription just looks like a new subscription that's never run.
Can anyone out there help, it would be appreaciated.
Many thanksCan you check to see if the corresponding SQL Agent job is firing and if
there are any issues? Also make sure that the ReportServer service is
running.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sandra" <Sandra@.discussions.microsoft.com> wrote in message
news:7D7C4C13-C9B6-4B15-9D6C-00DE601D15D9@.microsoft.com...
> Hi, I'm having some problems with email subscriptions.
> I've set up the subscription and schedule time but the schedule just
> doesn't
> seem to run. It's reporting no errors, there's nothing in the log and the
> subscription just looks like a new subscription that's never run.
> Can anyone out there help, it would be appreaciated.
> Many thanks|||I've checked the job and it is running correctly, the job is being inserted
into the Event table but it just doesn't move from there.|||You should check to see if the reportserver windows service is running. If
it is, check in the ReportServerService_<timestamp>.log file to see if there
are any errors indicating why the events are not being processed.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sandra" <Sandra@.discussions.microsoft.com> wrote in message
news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
> I've checked the job and it is running correctly, the job is being
> inserted
> into the Event table but it just doesn't move from there.|||Sandra,
Did you ever find a solution? We're having the same issue.
"Daniel Reib [MSFT]" wrote:
> You should check to see if the reportserver windows service is running. If
> it is, check in the ReportServerService_<timestamp>.log file to see if there
> are any errors indicating why the events are not being processed.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Sandra" <Sandra@.discussions.microsoft.com> wrote in message
> news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
> > I've checked the job and it is running correctly, the job is being
> > inserted
> > into the Event table but it just doesn't move from there.
>
>|||The problem was in the implementation. We just used the wrong timezone for
the execution date. Therefore the schedule was always created one hour before
the intended time. After changing the timezone in the code it worked!
"daw" wrote:
> Sandra,
> Did you ever find a solution? We're having the same issue.
> "Daniel Reib [MSFT]" wrote:
> > You should check to see if the reportserver windows service is running. If
> > it is, check in the ReportServerService_<timestamp>.log file to see if there
> > are any errors indicating why the events are not being processed.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Sandra" <Sandra@.discussions.microsoft.com> wrote in message
> > news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
> > > I've checked the job and it is running correctly, the job is being
> > > inserted
> > > into the Event table but it just doesn't move from there.
> >
> >
> >|||We have the same problem, but not related to time zone settings.
Before the subscriptions are running several month without problem.
SQL Agent is started, smtp server available. I can start the jobs direct in
SQL Agent jobs. The job is marked as successfull. No log entries where ever
possible. RS just don't start to create the report and send it. On the test
server it still works, everything is exact the same on the testsystem.
Before this occured the database log file was full. And we thought that
couses the problem. After fix this, the beheavoiour is still the same.
Has anybody a clues!
"Sandra Geisler" wrote:
> The problem was in the implementation. We just used the wrong timezone for
> the execution date. Therefore the schedule was always created one hour before
> the intended time. After changing the timezone in the code it worked!
> "daw" wrote:
> > Sandra,
> > Did you ever find a solution? We're having the same issue.
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > You should check to see if the reportserver windows service is running. If
> > > it is, check in the ReportServerService_<timestamp>.log file to see if there
> > > are any errors indicating why the events are not being processed.
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > >
> > >
> > > "Sandra" <Sandra@.discussions.microsoft.com> wrote in message
> > > news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
> > > > I've checked the job and it is running correctly, the job is being
> > > > inserted
> > > > into the Event table but it just doesn't move from there.
> > >
> > >
> > >|||Hello,
did I understand correctly, that the email subscription has the correct
start date and time, but does not start though?
"Dev Main" <DevMain@.discussions.microsoft.com> schrieb im Newsbeitrag
news:2892A909-D1A8-4FE4-B572-49B2FD36E457@.microsoft.com...
> We have the same problem, but not related to time zone settings.
> Before the subscriptions are running several month without problem.
> SQL Agent is started, smtp server available. I can start the jobs direct
> in
> SQL Agent jobs. The job is marked as successfull. No log entries where
> ever
> possible. RS just don't start to create the report and send it. On the
> test
> server it still works, everything is exact the same on the testsystem.
> Before this occured the database log file was full. And we thought that
> couses the problem. After fix this, the beheavoiour is still the same.
> Has anybody a clues!
> "Sandra Geisler" wrote:
>> The problem was in the implementation. We just used the wrong timezone
>> for
>> the execution date. Therefore the schedule was always created one hour
>> before
>> the intended time. After changing the timezone in the code it worked!
>> "daw" wrote:
>> > Sandra,
>> > Did you ever find a solution? We're having the same issue.
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> > > You should check to see if the reportserver windows service is
>> > > running. If
>> > > it is, check in the ReportServerService_<timestamp>.log file to see
>> > > if there
>> > > are any errors indicating why the events are not being processed.
>> > >
>> > > --
>> > > -Daniel
>> > > This posting is provided "AS IS" with no warranties, and confers no
>> > > rights.
>> > >
>> > >
>> > > "Sandra" <Sandra@.discussions.microsoft.com> wrote in message
>> > > news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
>> > > > I've checked the job and it is running correctly, the job is being
>> > > > inserted
>> > > > into the Event table but it just doesn't move from there.
>> > >
>> > >
>> > >|||Yes! Date and time are absolut correct. I veryfied this after reading your
post.
There are no log entries. Not in Event Viewer, not in log files from
reporting services.
"Sandra Geisler" wrote:
> Hello,
> did I understand correctly, that the email subscription has the correct
> start date and time, but does not start though?
>
> "Dev Main" <DevMain@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:2892A909-D1A8-4FE4-B572-49B2FD36E457@.microsoft.com...
> > We have the same problem, but not related to time zone settings.
> >
> > Before the subscriptions are running several month without problem.
> >
> > SQL Agent is started, smtp server available. I can start the jobs direct
> > in
> > SQL Agent jobs. The job is marked as successfull. No log entries where
> > ever
> > possible. RS just don't start to create the report and send it. On the
> > test
> > server it still works, everything is exact the same on the testsystem.
> >
> > Before this occured the database log file was full. And we thought that
> > couses the problem. After fix this, the beheavoiour is still the same.
> >
> > Has anybody a clues!
> >
> > "Sandra Geisler" wrote:
> >
> >> The problem was in the implementation. We just used the wrong timezone
> >> for
> >> the execution date. Therefore the schedule was always created one hour
> >> before
> >> the intended time. After changing the timezone in the code it worked!
> >>
> >> "daw" wrote:
> >>
> >> > Sandra,
> >> > Did you ever find a solution? We're having the same issue.
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> > > You should check to see if the reportserver windows service is
> >> > > running. If
> >> > > it is, check in the ReportServerService_<timestamp>.log file to see
> >> > > if there
> >> > > are any errors indicating why the events are not being processed.
> >> > >
> >> > > --
> >> > > -Daniel
> >> > > This posting is provided "AS IS" with no warranties, and confers no
> >> > > rights.
> >> > >
> >> > >
> >> > > "Sandra" <Sandra@.discussions.microsoft.com> wrote in message
> >> > > news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
> >> > > > I've checked the job and it is running correctly, the job is being
> >> > > > inserted
> >> > > > into the Event table but it just doesn't move from there.
> >> > >
> >> > >
> >> > >
>
>
