Groups | Blog | Home
all groups > sql server reporting services > october 2004 >

sql server reporting services : Subscription Not Firing Up


Vineet Dutt
10/13/2004 12:35:06 PM
Hello

I have created a standard subscription that takes a report (chart) and saves
it it to a network share - it is setup to run once and specified a time that
is a few minutes than current.

SQL Server Agent is running.

The subscription does not seem to be running, I have also checked the log
files and get the following:

!cf8!10/13/2004-15:30:39:: i INFO: Call to GetPermissions:/Test/Report7
w3wp!library!cf8!10/13/2004-15:30:39:: i INFO: Call to GetSystemPermissions


I have a feeling that I might be missing some basic concept here with the
setup - can anyone help please?

Thanks
Daniel Reib [MSFT]
10/13/2004 8:39:33 PM
Check the ReportServerService<date>.log file for any errors. Does the
status of the subscription ever change? Does the SQL agent job run
successfully? Is ReportServer service running?

--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

NI
10/14/2004 6:19:03 AM
Check your event table, notification table in the report sever DB. Also see
if the job is in the SQL agent. If it is (somethingz wrong with the SQl
server running maybe the account it is running under) try running it manually
from there.



[quoted text, click to view]
AddThis Social Bookmark Button