[dbo].[Forum_EmailQueue_TaskScheduleItemIDGet]

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

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@DeleteTask	bit	1

CREATE PROCEDURE dbo.Forum_EmailQueue_TaskScheduleItemIDGet @DeleteTask BIT
AS
    IF @DeleteTask = 1
        BEGIN
            SELECT  ScheduleID
            FROM    dbo.Schedule
            WHERE   TypeFullName = 'DotNetNuke.Modules.Forum.CleanupEmailQueuedTasks, DotNetNuke.Modules.Forum'
        END
    ELSE
        BEGIN
            SELECT  ScheduleID
            FROM    dbo.Schedule
            WHERE   TypeFullName = 'DotNetNuke.Modules.Forum.StartEmailQueuedTasks, DotNetNuke.Modules.Forum'
        END

GO