[dbo].[Forum_EmailQueue_TaskCleanTasks]

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

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@DeleteDate	datetime	8

SQL Script

CREATE PROCEDURE dbo.[Forum_EmailQueue_TaskCleanTasks]
@DeleteDate datetime
AS

DELETE
FROM
dbo.Forum_EmailQueue_Tasks
WHERE
QueueCompletedDate < @DeleteDate

GO

Uses

[dbo].[Forum_EmailQueue_Tasks]
dbo