Post reply

Reporting Service 2005 - Subcription

  • January 1, 2008 at 6:04 pm

    #177819

    Hi,

    I have setup the schedule to run on 2nd of Jan 2008 in my report.

    however it seems the schedule didn't run accordingly.

    This morning I run it again and it is ok.

    I just curious...where do I check it? I want to know why?

    Thanks,

    Susan

  • January 2, 2008 at 6:54 am

    #764019

    Did you check the job on the Server that Reportserver database run on?

    You create subscription and schedule, it should have on that server.

    I just did it last week and it did not run so I need to recreate it.

    At first I did not refresh the job and I try to rename the job (it show up as some name that machine create) and it did not work.

    I delete all previous jobs and recreate subscription and leave the name as is and it run perfect.

    Note: The reason the I rename the job is to try to activate it from other stored procedure in another server.

  • January 2, 2008 at 8:36 am

    #764068

    Did you check if sql server agent was running on the server?

  • January 2, 2008 at 4:09 pm

    #764213

    HI,

    I am running the job schedule from report manager.

    I think the sql server is running too. cos in the morning I run the schedule and it is ok already.

    thanks,

    Susan

  • January 3, 2008 at 1:30 am

    #764281

    OK thats good to hear.

    Just for the info.

    When you create a schedule in reporting services, there will be automatically made a job in SQL Server agent. So the SQL Server agent always needs to be running to send the reports on a defined schedule.

    Greetings

    Niels Naglé

  • January 6, 2008 at 3:32 pm

    #765178

    Thanks Everyone

Viewing 6 posts - 1 through 5 (of 5 total)

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