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: Joe Webb
Date: Tue, 17 Jul 2007 13:42:11 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
On Tue, 17 Jul 2007 12:37:59 -0500, James wrote:

> I do own your book too  :-)
> 
> 
> 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


Thanks! I hope you've found the book helpful. 

-- 
Joe Webb
SQL Server MVP
http://www.sqlns.com

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