Set SSRS to Run By the Hour

Posted on 2011-05-10
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
    LVL 4

    Accepted Solution

    LVL 16

    Expert Comment

    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

    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
    LVL 16

    Expert Comment

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

    Author Comment

    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

    Well, i do not have detailed explanation

    but when you actually open up a job created by SSRS 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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now