SSRS Report run by SQL Agent job


All replies

  • Abdul,

    I m not sure whether i understood your requirement correctly or not. Are you interested in scheduling the ssrs report for your end users via fileshare/Email?

    If so, SSRS provides the subscriptions features which will help you acheive the same functionality that we get using the sql server agent.

    Pls check this link to get an insight on data driven subscription


    Regards, KarthikShanth. "Mark as Answer" if this helps you!

    Shanth's techwitz

    ↑ Grab this Headline Animator

    Disclaimer: The contents, I write here are my personal views, not the view of my employer and anyone else.
    Friday, June 25, 2010 7:29 AM
  • After creating a subscription in Report Manager the subscription GUID becomes the name of the SQL Job, I wrote the following script to associate the report subscription to the SQL job.

    HINT: You may need to change the collation in the script.


    PROC usp_scheduled_reports






    'exec msdb.dbo.sp_start_job @job_name = ' + CHAR(39) + CONVERT(VARCHAR(100), COLLATE SQL_Latin1_General_CP1_CI_AS ) + CHAR(39) + ' -- ' + FROM msdb.dbo.sysjobs sjs


    INNER JOIN ReportSchedule rs ON rs.ScheduleID = CAST( AS UNIQUEIDENTIFIER)



    INNER JOIN ReportServer.dbo.Catalog c ON rs.ReportID = c.ItemID


    WHERE category_id IN (SELECT category_id FROM msdb.dbo.syscategories WHERE name = 'Report Server')








    Wednesday, April 13, 2011 4:39 PM
  • Hi,

    What is Repoertschedule table in above query and what should be general columns int it.

    if i configure job to execute ssrs subscription multple times by specifying multiple steps in job.

    i.e I want to execute one job having multiple steps and each step will execute same report with different parameters.

    Friday, June 03, 2011 10:38 AM