Reporting Services Sheduled job Failing

  • On SqL Server 2005 Std Edition Along with reporting services with sp2 we have more that 50 reports and these 50 reports are sheduled to run automatically, but it is not running as per sheduled however when we are trying to run the job it is running sucessfully.

    Issue is we want this job to be run automatically without any human interface.

    Please suggest us on the same

  • The things to check are Agent permissions, SMTP or Exchange configuration if you are not using IIS SMTP, you have to check to make sure everything was setup as expected.

    Kind regards,
    Gift Peddie

  • hi

    Exact issue is that out of 250 reports only 50 reports are running sucessfully. manually we can run the reports and what is the permission we can check on Agent for the same.

    Bala

  • If 50 are running then it may be capacity related if you are using IIS SMTP then you may have to use Exchange because IIS SMTP load may not be up to 250 so you could try running 50 at a time so try five subscriptions.

    Kind regards,
    Gift Peddie

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

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