I’m doing a video/demo on BAM-Alerts. I’m using BT2006 with SQL2000 for my BAM/OLAP Cubes.
The BAMP
1) I set up my BAM Alert on the BAM Portal, and subscribed both by email and by file.
2) I verified that the service NS$BAMALERTS is running, and I ran the underlined command below to hopefully enable everything.
3) I dropped my test file that should have matched the criteria and
4) I checked BAMPrimaryImport – data is there okay, and in CUBE/PivotTable as well.
5) I checked email and disk “ALERTS” file, and nothing in either one.
So how can you debug, trace or test the alerts?
————————————————————————-
c:\Program Files\Microsoft SQL Server Notification Services\v2.0.3008.0\Bin>
nscontrol status -name BAMAlerts
Microsoft Notification Services Control Utility (Enterprise) (SP1) 2.0.3008.0
Copyright (C) Microsoft Corporation 2003. All rights reserved.
Status of instance “BAMAlerts”:
Subscribers: Enabled
Application: Application
Hosted event providers
1406441288632674338917802679008137106687687006109 (NEALWALTERS): Enabled
4602995236573838190167432623480152461874013981669 (NEALWALTERS): Enabled
1064532241439384512339293020394664983112871122326 (NEALWALTERS): Enabled
125362249098237454813316715232105279389353527569 (NEALWALTERS): Enabled
Non-hosted event providers
Generator
ApplicationGen1 (NEALWALTERS): Enabled
Distributors
ApplicationDist1 (NEALWALTERS): Enabled
Subscriptions: Enabled
Windows services
NS$BAMAlerts (NEALWALTERS): The service is running
Thanks,
Neal