Post reply

Need t-sql to list all enabled and scheduled SSRS jobs

  • April 25, 2016 at 7:08 am

    #318439

    Looking for T-SQL to generate a list of all SSRS "enabled, scheduled jobs" which run Reporting Services subscriptions.

    It must list "enabled, scheduled jobs" (disabled and/or unscheduled jobs must not be included) thx in advance

    BT

  • April 25, 2016 at 7:43 am

    #1874232

    something like this should get you started;

    select

    e.name

    , e.path

    , d.description

    , a.SubscriptionID

    ,b.enabled

    , laststatus

    , eventtype

    , LastRunTime

    , date_created

    , date_modified

    FROM ReportServer.dbo.ReportSchedule a

    INNER JOIN msdb.dbo.sysjobs b

    ON convert(varchar(40),a.ScheduleID) = b.name

    INNER JOIN ReportServer.dbo.ReportSchedule c

    ON b.name = convert(varchar(40),c.ScheduleID)

    INNER JOIN ReportServer.dbo.Subscriptions d

    ON c.SubscriptionID = d.SubscriptionID

    INNER JOIN ReportServer.dbo.Catalog e

    ON d.report_oid = e.itemid

    WHERE 1 = 1

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • April 27, 2016 at 4:49 am

    #1874886

    thanks Lowell - I will work with this SQL. Much appreciated!

    BT

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply