Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2009-05-06
2
Medium Priority
?
218 Views
Last Modified: 2012-05-06
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
Comment
Question by:Rhonda Carroll
2 Comments
 
LVL 6

Accepted Solution

by:
mvgeertruyen earned 750 total points
ID: 24318083
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
 
LVL 17

Assisted Solution

by:dbaSQL
dbaSQL earned 750 total points
ID: 24344558
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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question