Post reply

How to schedule SSRS subscription via Sql server job agent

  • November 8, 2012 at 4:55 am

    #269977

    hi,

    i have schedule some job by sql server job agent ant to generate report after completion of specific step.

    can any body help me to configuring the job agent.

  • November 8, 2012 at 4:58 am

    #1557116

    I would create the subscription as you would normally via SSRS front end, then I would remove the schedule from the job it creates to run that subscription. Then in the job which you want to start the subscription from, add a step which executes sp_start_job and pass in the job id of the subscription job.

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

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