microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: SQL-NS 2005 StockBroker Sample doesn't notify

Subject: Re: SQL-NS 2005 StockBroker Sample doesn't notify
From: "James"
Date: Tue, 17 Jul 2007 12:37:00 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Joe, again, this is straight from the BOOKs CD.  I only execute exactly what 
the book says.  Buy the book, and follow the instructions yourself and you 
will see what I mean, then we will be talking apples

thanks,

JIM


"Joe Webb" <[email protected]> wrote in message 
news:[email protected]
> On Wed, 20 Jun 2007 13:47:06 -0500, james wrote:
>
>> Thank you for the reply.  I made the folder public etc... but still 
>> nothing.
>> I am running the 1st sample from the book's CD, so everything is supposed 
>> to
>> just work as far as subscribers... they are all setup by Shyam's code.
>>
>> Thanks again
>>
>> JIM
>>
>> "Joe Webb" <[email protected]> wrote in message
>> news:[email protected]
>>> On Tue, 12 Jun 2007 15:24:36 -0500, James wrote:
>>>
>>>> This is what I see in the NotificationBatchesStatusCodes table
>>>>
>>>>       0 Undone
>>>>       1 Generating
>>>>       2 Generated
>>>>       3 Creating distributor work items
>>>>       4 Created distributor work items
>>>>       5 Failed to generate
>>>>       NULL NULL
>>>>
>>>>
>>>> JIM
>>>>
>>>>
>>>> "James" <[email protected]> wrote in message
>>>> news:[email protected]
>>>>> From Ch.3 of Shyam Pather's SQL-NS book, I have followed the
>>>>> instructions
>>>>> exactly as stated in the book, I get success on the TEST and setup_all
>>>>> and
>>>>> I get no errors when aI start the service as described on pg. 69-70. 
>>>>> I
>>>>> run the Test.sql file that inserts records in the StockBroker 
>>>>> database,
>>>>> and it runs without any errors. However, the file
>>>>> 'FileNotifications.txt'
>>>>> is NOT written to no matter hopw long I wait.  What gives?
>>>>>
>>>>>
>>>>>
>>>>> Thanks,
>>>>>
>>>>>
>>>>>
>>>>> James Klett
>>>>>
>>>>> jimklett @ mathias-die . com
>>>>>
>>>>>
>>>>>
>>>
>>> Double check to make sure you have subscribers, subscriber devices, and
>>> subscriptions set up. That's the most common problem for the symptoms
>>> you've described.
>>>
>>> Also, you may want to ensure that the service account has write
>>> permissions for the output folder.
>>>
>>> HTH...
>>>
>>>
>>> -- 
>>> Joe Webb
>>> SQL Server MVP
>>> http://www.sqlns.com
>
>
> Check the tables to make sure you do indeed have subscribers,
> subscriptions, and subscriberdevices. You can also check to see if there
> are notifications that have been produced by not delivered.
>
> HTH...
>
> Joe
>
>
> -- 
> Joe Webb
> SQL Server MVP
> http://www.sqlns.com 



<Prev in Thread] Current Thread [Next in Thread>