Archive for the 'sql2growl' Category

As mentioned in my previous Sql2Growl post I would come back to you if I had more info. Well here it is: The installation consists of two parts (both included in the zip): One is to setup the objects in the database (personally I am always a bit reserved to have a setup touch my databases, but if there is a user demand for it, I might integrate the setup of database objects in the installation set). The seconds is to install the NT service that interacts with the database and upon receiving a notification forwards it to Growl. To send a notification from the database execute the following procedure (assuming that the defaults in the SQL script where used):

EXEC [Growl].[spQueueNotification]
   @Application = N'Test App',
   @Type = N'Executed',
   @Title = N'Test Title',
   @Message = N'Test message\nline two' -- use \n for newline

Other parameters:

-- set to 1 to clear cached Growl objects
--
@ClearCachedObjects = 0

-- The service will look for the icon in Icons folder of
-- installed service and append .png to the name
--
@Icon = 'name'

-- usually only needed if notification has to be
-- forwarded to other Growl instance
--
@Password = 'password'

-- if you want the notification to be forwarded to
-- another Growl instance, it's preferred to setup
-- forwarding in Growl itself
--
@Host = 'hostname'

-- In the rare situation that Growl is not listening on the default
-- port, you can specify the port
--
@Port = '23053'

I decided to host the project on GitHub for two reasons. a) to play around with Git and b) because it is hip
Here is the setup: Sql2Growl_1.1.zip
And here is the git repository url: sql2growl