Report Schedules

 4 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Robby
Veteran Member
Posts: 87
Veteran Member
    Good Morning,

    We're running LBI (201105) 9-0-4-2-137

    We have reports scheduled nearly everyday, normally they run with no problems.

    However, yesterday and this morning, no reports ran as scheduled. (I have a Smart Note to alert me to this fact).

    Due to the nature of the reports, I needed to send them manually (so payroll could get their data).

    While running a couple manually, the rest of them "started" back up and sent themselves out?!?!

    Is there a mechanism within the scheduling logic that sends out reports that have missed their "fire" time?

    thanks in advance!

    -Robby
    Matthew Nye
    Veteran Member
    Posts: 514
    Veteran Member
      From Reporting Services Administration:

      System Settings > Job Scheduler Settings > Default Job Recovery Rule
      If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
      Robby
      Veteran Member
      Posts: 87
      Veteran Member
        Thanks for the roadmap,

        I went to Reporting Services Administration:

        Server Administration>Job Scheduler Settings:

        Under "General Properties" I found a drop-down selector for "Default Job Recovery Rule" Ours is set to "None".

        Choices are: "None", "Recover Job" & "Reschedule".

        Just curious what each of these does?...since ours is "None" and they re-triggered themselves (or at least they seemed too)
        Matthew Nye
        Veteran Member
        Posts: 514
        Veteran Member
          theres also Report Schedule Queuing (which actually IS in System Settings, i gave you the wrong breadcrumb for the job scheduler, as you noted).

          Perhaps your jobs were queued up before failure and when the system was brought back online it just started processing the queue. difficult one to troubleshoot without logs though.
          If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
          Randy Leighton
          New Member
          Posts: 3
          New Member
            I don't see Report Schedule Queuing in the System Settings. I've scheduled several reports through LBI. Eventhough they appear to be scheduled, they don't appear in the Job Schedule. When I click the Maintain Schedules link, I see the schedule and it show the job has run. Again, nothing in the Job Schedule. Anybody know why? Thanks.