quote:

---

Originally posted by Kristen

If its a Web app you could have a little window with a META REFRESH that checks to see if there are "reminders" every minute. But it will only work if it is maximise (doesn't have to be the current window though)

For a Windows app you could have something which WILL run when minimised that does a SQL query every minute, say.

Or, as you say, you could run an EMailing task on the SQL box that sends Emails periodically. I would suggest running it more frequently than 30 minutes for a one hour reminder (10 minutes sounds about right) - someone might be registered 29 minutes before departure - does that need to cause a Reminder Email?

Keep in mind that EMail is not guaranteed-delivery - so once in a while the Email won't get to the recipient ...

For a really cheap&cheerful solution you could use ServersAlive and set it to run a SQL query every few minutes and to treat the query as FAILURE when there are items to be viewed - the user then has to view, and "cancel" the items, for the FAILURE to be cleared. ServersAlive can make a horrible noise on "failure" :-)

Maybe even better would be to use MSAgent - the text-to-speech animated thigie. That could go runnign all round the user's screen with all sorts of useful speech-balloons and voice-output messages ....

... maybe I'm getting a little carried away!

Kristen

---

DECLARE @strCommand varchar(8000), @intRowCount int
SELECT @intRowCount = 1 -- Force first loop iteration
WHILE @intRowCount > 0
BEGIN
    SELECT TOP 1 @strCommand = 'NET SEND ' + OperatorsName 
                             + ' "' + PasengerName + ' arrives at ' 
                             + ArrivalTime + '"',
                 @MyID = MyID
    FROM MyTable
    WHERE     ArrivalTime < DATEADD(Minute, 60, GetDate())
          AND ArrivalAnnounced = 0
    SELECT @intRowCount = @@ROWCOUNT
    IF @intRowCount > 0 EXEC master.dbo.xp_cmdshell @strCommand
    UPDATE U 
    SET    ArrivalAnnounced = 1 
    FROM   MyTable U
    WHERE  MyID = @MyID
END

-- Get just date
SELECT	DATEADD(Day, DATEDIFF(Day, 0, GetDate()), 0)

-- Get just time
SELECT	GetDate() - DATEADD(Day, DATEDIFF(Day, 0, GetDate()), 0)

-- Both together
SELECT	DATEADD(Day, DATEDIFF(Day, 0, GetDate()), 0)
        + (GetDate() - DATEADD(Day, DATEDIFF(Day, 0, GetDate()), 0))

SELECT	DATEADD(Day, DATEDIFF(Day, 0, DateField), 0)
        + (TimeField - DATEADD(Day, DATEDIFF(Day, 0, TimeField), 0))