Showing posts with label stays. Show all posts
Showing posts with label stays. Show all posts

Monday, March 26, 2012

New Subscriptions Never Run.

Hello,
For some reason all of the suden any subscription I make will not run..
The status just stays at "New Subscription". I made a test schedule
that runs every 5 minutes.
I have even added old subscriptions to this schedule and I get email
every 5 minutes. Why would Any new subscription I make not be running?
I don't even get an error message under the status heading in the
Subscription list.
Thanks,
JeffJeffrae wrote:
> Hello,
> For some reason all of the sudden any subscription I make will not run..
> The status just stays at "New Subscription". I made a test schedule
> that runs every 5 minutes.
> I have even added old subscriptions to this schedule and I get email
> every 5 minutes. Why would Any new subscription I make not be running?
> I don't even get an error message under the status heading in the
> Subscription list.
> Thanks,
> Jeff
I notice that Subscriptions.MatchData appears to be different then all
of the rest... What is this field?|||Jeffrae wrote:
> Hello,
> For some reason all of the suden any subscription I make will not run..
> The status just stays at "New Subscription". I made a test schedule
> that runs every 5 minutes.
> I have even added old subscriptions to this schedule and I get email
> every 5 minutes. Why would Any new subscription I make not be running?
> I don't even get an error message under the status heading in the
> Subscription list.
> Thanks,
> Jeff
Microsoft SQL Server 2000.