[dbo].[Forum_EmailQueue

[dbo].[Forum_EmailQueue_TaskGetNext]

(local) > DotNetNuke_Community > Stored Procedures > dbo.Forum_EmailQueue_TaskGetNext

Properties
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

SQL Script

CREATE PROCEDURE dbo.[Forum_EmailQueue_TaskGetNext]
AS
SELECT TOP 1 *
FROM dbo.Forum_EmailQueue_Tasks
WHERE
    SendComplete = 0
AND
    ScheduleStartDate < GetDate()
AND
    TaskFailedCount < 2
ORDER BY
    QueuePriority, QueueAddedDate

GO

Uses

[dbo].[Forum_EmailQueue_Tasks]
dbo