USP_DATALIST_TRANSACTIONALEMAILJOBSPROCESSED

Parameters

Parameter	Parameter Type	Mode
@SPECIFICDATE	date	IN
@COMPLETEDLABEL	nvarchar(100)	IN
@FILTERMODE	tinyint	IN
@SELECTEDWEEK	tinyint	IN
@SELECTEDMONTH	int	IN
@SELECTEDYEAR	int	IN

Definition

Copy



create procedure dbo.USP_DATALIST_TRANSACTIONALEMAILJOBSPROCESSED
(
@SPECIFICDATE date = null
,@COMPLETEDLABEL nvarchar(100) = null
,@FILTERMODE tinyint = 0  --0: Today mode ,1: Specific day mode, 2: Week/Month/Year

,@SELECTEDWEEK tinyint = 0 --0:All weeks of selected month, 1:First week, 2:Second week, 3:Third week, 4:Fourth week

,@SELECTEDMONTH integer = 0 --00: All months of selected year, 01: Jan, 02: Feb ....12: Dec

,@SELECTEDYEAR integer = 2011 --Year drop down

)
as
begin
    set nocount on;

exec dbo.USP_WIDGETDASHBOARD_EMAILJOBSPROCESSED @SPECIFICDATEPARAMETER=@SPECIFICDATE,@COMPLETEDLABELPARAMETER=@COMPLETEDLABEL,@FILTERMODEPARAMETER=@FILTERMODE,@SELECTEDWEEKPARAMETER=@SELECTEDWEEK,@SELECTEDMONTHPARAMETER=@SELECTEDMONTH,@SELECTEDYEARPARAMETER=@SELECTEDYEAR,@ISINCLUDEGENERALPURPOSEEMAILJOBSPARAMETER=0,@ISINCLUDETRANSACTIONALEMAILJOBSPARAMETER=1
end