I have found a bug in 4.0.1 where no notifdications will be sent due to an error in a SPROC. Run this from Host/SQL, tick 'Run as script' and click Execute. This will be included in 4.0.2. Logged in Gemini here - EVT-8108
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}EventsNotificationsToSend]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}EventsNotificationsToSend]
GO
CREATE PROCEDURE {databaseOwner}{objectQualifier}EventsNotificationsToSend
(
@NotifyTime DateTime
)
AS
SELECT n.NotificationID, n.EventID, n.PortalAliasID, n.UserEmail,
n.NotificationSent, n.NotifyByDateTime, n.EventTimeBegin, n.NotifyLanguage,
e.TimezoneOffset, n.ModuleID
FROM {databaseOwner}[{objectQualifier}EventsNotification] as n INNER JOIN
{databaseOwner}[{objectQualifier}Events] as e ON n.EventID = e.EventID AND n.NotifyByDateTime <= DATEADD(minute, e.TimezoneOffset,
@NotifyTime)
WHERE (n.NotificationSent = 0)
ORDER BY n.NotifyByDateTime
GO