USP_DATALIST_JOBSCHEDULEREPORT

Returns summary information for activated mailings.

Parameters

Parameter	Parameter Type	Mode	Description
@JOBID	uniqueidentifier	IN	Job
@JOBOCCURRENCEID	uniqueidentifier	IN	Job Occurrence
@DEPARTMENTID	uniqueidentifier	IN	Department
@FROM	datetime	IN	From
@TO	datetime	IN	To
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



        CREATE procedure dbo.[USP_DATALIST_JOBSCHEDULEREPORT]
        (
                @JOBID uniqueidentifier = null,
                @JOBOCCURRENCEID uniqueidentifier = null,
                @DEPARTMENTID uniqueidentifier = null,
                @FROM datetime = null,
                @TO datetime = null,
                @CURRENTAPPUSERID uniqueidentifier = null
        )
        as
          set nocount on;

          exec dbo.USP_REPORT_JOBOCCURRENCESCHEDULE @JOBID, @JOBOCCURRENCEID, @DEPARTMENTID, null, @FROM, @TO, @CURRENTAPPUSERID

          return 0;