How to make schedule jobs to run without skipping in Bold BI Windows application

In a Windows environment, the data source Data Refresh and the Dashboard schedule may be skipped if the Windows server or Bold BI application is restarted.

During the Bold BI site deployment in IIS, the recycling time interval has been set in the application pool at 1740 minutes, i.e., 29 hours, which is the default value, to recycle the application pool every 29 hours to avoid issues such as application deadlock and memory leakage. Once the recycling time interval is reached, the application pool will stop the Bold BI service until the first request is sent for the application. Once a request is received for the BI site, the site automatically goes up and the schedule gets running, otherwise, schedules will be skipped until the initial hit is received.

Steps to avoid the automatic shutdown of the BI Jobs service

Follow the steps below to overcome the schedule job skipping issue,

1. Go to the Internet Information Services (IIS) Manager.
   

   

2. Select the Application Pools from the left panel by expanding the Connections.
   

   

3. In the Application Pools list, select the BoldBIJob application pool name.
   

   

4. Click on the Advanced Settings option in the right panel.
   

   

5. Set zero for the “Regular Time Interval” and “Idle Time-out” and click OK.
   

   

6. Now, the BI job service will not stop automatically, and the schedule won’t be interrupted.

7. You can monitor the data refresh or dashboard schedule after the next 29 hours and confirm the schedule is continuously running without skipping.

How to find the Application Pool of BI Job Service

1. Expand the Sites section and select the Bold BI hosted site,
   

   

2. Expand and go to bi -> jobs under the site name and select it.
   

   

3. Click on the Advanced Settings option in the right panel.
   

   

4. In the Application Pool section, you can find the name of the BIJobs application pool for your hosted application to which we need to set the “Regular Time Interval” and “Idle Time-out” as mentioned above.
   

   

5. The BIJobs application pool should not be used for other paths.