Unable to see subscriptions

  • I have a reporting services setup that I inherited. SQL 2005 SP3. I am a sysadmin on SQL Server, administrator on the server, and I also have an account with domain admin rights that I have tried. I am unable to view any subscriptions for reports. I see SQL Agent jobs for reporting services. I know that some files (XLS) are being placed on a network share based on a report on the report server. However if I go to that report I can not see any subscriptions.

    Does anyone know how I can view the subscriptions? I need to make a change but I have no information as the previous admin is no longer available. So I assume it was created under his account, but thats just a guess. I want to alter the schedule/delivery options if I can get to see the subscription.

    Thankss.

  • Use subscription table in Reportserver database

    select * from subscriptions

    Hope this will help you

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

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

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