Set SSRS to Run By the Hour

Posted on 2011-05-10
Medium Priority
Last Modified: 2012-05-11
I want to set up SSRS to run between the hours of 8am to 5pm on week days.

I only see hourly with a starting time but no ending.

Is it possible?

Question by:jaymz69
  • 3
  • 2

Accepted Solution

jimtpowers earned 1000 total points
ID: 35731247
LVL 16

Expert Comment

ID: 35732397
I would suggest you create a subscription to run everyday at 8 AM and then you can define another SQL job to run this subscription every hour from 9am-5pm

you can use the below SQL to find the JobId created by the SSRS subscription and use it in the SQL job to run the Subscription

SELECT R.ScheduleID as JobName,S.Description,S.LastStatus,S.LastRunTime FROM dbo.Subscriptions S
INNER JOIN dbo.ReportSchedule R
ON S.SubscriptionID = R.SubscriptionID and S.Description Like '%XXXX%';

Use this Code in the SQL Job and schedule it to run every hour

USE msdb ;

EXEC dbo.sp_start_job N'SSRS Subscription Job Id' ;

Author Comment

ID: 35732446
We went to SQL Server Agent
   - Jobs
   - Find the job and click properties
   - Select Schedules
   - Edit
   - There are all the properties I need to change
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

LVL 16

Expert Comment

ID: 35732612
You can always do that but Its not advisable to change the properties of a job Scheduled using SSRS

Author Comment

ID: 35732902
why is that? I am new to SQl Server

That properites has what I need in it to control the 8 - 5 on the hour report running.
LVL 16

Assisted Solution

vdr1620 earned 1000 total points
ID: 35732967
Well, i do not have detailed explanation

but when you actually open up a job created by SSRS ..you can see the message that says as below
"This job is owned by a report server process. Modifying this job could result in database incompatibilities. Use Report Manager or Management Studio to update this job."

and also i remember reading an article about the same issue way back.. you might have to google if you want more explanation.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question