USP_DATALIST_WIDGETDASHBOARD_GENERALPURPOSEEMAILJOBS

Reporting on the status of general purpose email jobs.

Parameters

Parameter	Parameter Type	Mode	Description
@SPECIFICDATE	date	IN	Specific date
@FILTERMODE	tinyint	IN	Select option
@STARTDATE	date	IN	Start date
@ENDDATE	date	IN	End date
@INCLUDEQUEUEDJOBS	bit	IN	Queued
@INCLUDEPROCESSINGJOBS	bit	IN	Processing
@INCLUDECOMPLETEDJOBS	bit	IN	Completed
@INCLUDECANCELEDJOBS	bit	IN	Canceled
@INCLUDEDELETEDJOBS	bit	IN	Deleted
@INCLUDESTOPPEDORPAUSEDJOBS	bit	IN	Stopped or Paused
@INCLUDEERRORJOBS	bit	IN	Error
@QUEUEDLABEL	nvarchar(100)	IN
@PROCESSINGLABEL	nvarchar(100)	IN
@COMPLETEDLABEL	nvarchar(100)	IN
@CANCELEDLABEL	nvarchar(100)	IN
@DELETEDLABEL	nvarchar(100)	IN
@STOPPEDORPAUSEDLABEL	nvarchar(100)	IN
@ERRORLABEL	nvarchar(100)	IN

Definition

Copy



CREATE procedure dbo.USP_DATALIST_WIDGETDASHBOARD_GENERALPURPOSEEMAILJOBS
(
@SPECIFICDATE date = null
,@FILTERMODE tinyint = 0  --0: Today mode ,1: Specific day mode, 2:Date range start date and end date
,@STARTDATE date = null
,@ENDDATE date = null
,@INCLUDEQUEUEDJOBS bit = 1
,@INCLUDEPROCESSINGJOBS bit = 1
,@INCLUDECOMPLETEDJOBS bit = 1
,@INCLUDECANCELEDJOBS bit = 1
,@INCLUDEDELETEDJOBS bit = 1
,@INCLUDESTOPPEDORPAUSEDJOBS bit = 1
,@INCLUDEERRORJOBS bit = 1
,@QUEUEDLABEL nvarchar(100) = null
,@PROCESSINGLABEL nvarchar(100) = null
,@COMPLETEDLABEL nvarchar(100) = null
,@CANCELEDLABEL nvarchar(100) = null
,@DELETEDLABEL nvarchar(100) = null
,@STOPPEDORPAUSEDLABEL nvarchar(100) = null
,@ERRORLABEL nvarchar(100) = null
)
as
    set nocount on;

select @STARTDATE=STARTDATE, @ENDDATE=ENDDATE from dbo.UFN_WIDGETDASHBOARD_GETSTARTENDDATE(@STARTDATE,@ENDDATE,@SPECIFICDATE,@FILTERMODE)

--select @STARTDATE as start_date, @ENDDATE as end_date 

select ID, STATUSLABEL, NUMOFEMAILJOBS from dbo.UFN_GET_EMAILPROCESS_JOBSTATUS(@STARTDATE,@ENDDATE,0,@INCLUDEQUEUEDJOBS,@INCLUDEPROCESSINGJOBS,@INCLUDECOMPLETEDJOBS,@INCLUDECANCELEDJOBS,@INCLUDEDELETEDJOBS,@INCLUDESTOPPEDORPAUSEDJOBS,@INCLUDEERRORJOBS,@QUEUEDLABEL,@PROCESSINGLABEL,@COMPLETEDLABEL,@CANCELEDLABEL,@DELETEDLABEL,@STOPPEDORPAUSEDLABEL,@ERRORLABEL)
order by NUMOFEMAILJOBS desc