Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

How can I get my subscription reports in reporting services 2000 to run again after sudeenly stopping?

Hi,

I have many reports setup on subsciptions and they haven't been running in the last 2 days. I logged on the server and found out the disk space was very low so the server guys cleaned up some extra room. However, they still don't work. i tried a test run but nothing happened.

Any idea what needs to be done here or where I can check to see if a problem exists?

Thanks,
Rhonda
0
Rhonda Carroll
Asked:
Rhonda Carroll
2 Solutions
 
mvgeertruyenCommented:
They expire after 14 days so you should still be good. Make sure the log reader job and distribution jobs are started (SQL agent). Have a look in the replication monitor for errors.
0
 
dbaSQLCommented:
I have had this problem once before myself.  take a look at this:
http://blogs.msdn.com/psssql/archive/2009/02/02/why-aren-t-my-subscriptions-working.aspx
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now