MS SQL Server
  Home arrow MS SQL Server arrow Page 3 - Creating Important Aspects of Notification...
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
ASP Web Hosting  
ASP.NET Web Hosting 
Dedicated Servers 
Actuate Whitepapers 
VeriSign Whitepapers 
Windows Web Hosting
 
IBM® developerWorks 
Sun Developer Network 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
IBM developerWorks
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
MS SQL SERVER

Creating Important Aspects of Notification Services
By: O'Reilly Media
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 5 stars5 stars5 stars5 stars5 stars / 1
    2007-03-22

    Table of Contents:
  • Creating Important Aspects of Notification Services
  • Creating an Event Provider
  • Creating a Generator
  • Creating a Vacuum Schedule
  • Creating a Subscription
  • Enumerating a Notification Services Instance Database
  • Enumerating a Notification Services Application Database

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT

    Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

    Creating Important Aspects of Notification Services - Creating a Generator


    (Page 3 of 7 )

    A generator named StockWatchGenerator is created in the CreateGenerator() method of Example 18-1. The code follows:

      private static void CreateGenerator()
      {
         // create a new generator for the application
         Generator g = new Generator(a, "StockWatchGenerator");
         g.SystemName = nsServer;
         a.Generator = g;

         Console.WriteLine("Created generator: " + g.Name);
      }

    TheGeneratorobject represents the generator for a Notification Services application. TheGenerator property of theApplication class returns the generator for the application. You have to specify theGeneratorproperty of theApplicationobject before adding the application to the Notification Services instance. An application has only one generator, which handles rule processing for the application.

    TheSystemNameproperty of theGenerator class must be specified, and cannot be any of the following:localhost,., an IP address, or any string containing a backslash (\).

    Creating a Distributor

    A distributor named StockWatchDistributor is created in the CreateDistributor() method of Example 18-1. The code follows:

      private static void CreateDistributor()
      {
         
    Distributor d = new Distributor(a, "StockWatchDistributor");
         
    d.SystemName = nsServer;
         
    d.QuantumDuration = new TimeSpan(0, 0, 15);
         
    a.Distributors.Add(d);

          Console.WriteLine("Added distributor: " + d.Name);
      }

    TheDistributor object represents a distributor for a Notification Services application. Each application must have one distributor that controls formatting and distribution of notifications. If an application has multiple distributors, each one must be installed on a different server. TheQuantumDurationproperty specifies the distributor work item polling interval, which is 15 seconds in this example.

    The NMO classes for managing distributors are described in Table 18-11.

    Table 18-11. NMO classes for managing distributors

    Class Description
    Distributor Represents a distributor for a Notification Services application.
    DistributorCollection Represents a collection of distributors asDistributorobjects. TheDistributors property of theApplicationclass returns the distributors used to distribute notifications to delivery channels for the Notification Services application.

    More MS SQL Server Articles
    More By O'Reilly Media


       · This article is an excerpt from the book "Programming SQL Server 2005," published by...
     

    Buy this book now. This article is excerpted from chapter 18 of Programming SQL Server 2005, written by Bill Hamilton (O'Reilly, 2006; ISBN: 0596004796). Check it out today at your favorite bookstore. Buy this book now.

    MS SQL SERVER ARTICLES

    - Completing the Introduction to Transact-SQL
    - A Brief Introduction to Transact-SQL
    - Lookups and Blocking Bad Data
    - Field Validation Rules for Blocking Bad Data
    - Using Masks to Block Bad Data
    - Blocking Bad Data
    - Using @@ROWCOUNT and TABLE Variables for Dat...
    - How to Use Variables, IF and CASE in Databas...
    - Creating Important Aspects of Notification S...
    - Working wth Variables in Database Interactio...
    - Delving Deeper into Notification Services
    - Notification Services
    - Building a Multi-table Report with SQL 2005 ...
    - A Secure Way of Building Connection Strings
    - Transferring a Database Using the SSIS Desig...





    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway