Home Forums Reporting Services Reporting Services Subscriptions from Reporting Services get unintelligable job names in SQL Server Agent RE: Subscriptions from Reporting Services get unintelligable job names in SQL Server Agent

  • May 22, 2008 at 4:36 pm

    #819424

    Prakash.Bhojegowda (2/13/2008)

    Thanks Jason,

    Would you mind taking a look at another question that I have?

    I have a Network Load Balanced Web Farm ( 2 Nodes configured as Active - Active) with SQL Reporting services installed. Report Server database is on the SQL server. When I subscribe a report on the cluster, it appears on bothe nodes. My question is: Will the report be kicked off on both the nodes of the web farm?

    Any help would be appreciated.

    Thanks

    Prakash BhojeGowda

    No, it will not, the report is a SQL Job, not a web server job. The subscriptions are independent of the number of front end servers you have in the RS Farm.