USP_REPORT_JOBOCCURRENCESCHEDULESERVER

Stored procedure as datasource for server side job occurrence schedule report.

Parameters

Parameter	Parameter Type	Mode
@JOBID	uniqueidentifier	IN
@JOBOCCURRENCEID	uniqueidentifier	IN
@DEPARTMENTID	uniqueidentifier	IN
@RANGE	int	IN
@FROM	datetime	IN
@TO	datetime	IN
@REPORTUSERID	nvarchar(128)	IN
@ALTREPORTUSERID	nvarchar(128)	IN

Definition

Copy



            CREATE procedure dbo.USP_REPORT_JOBOCCURRENCESCHEDULESERVER(
                @JOBID uniqueidentifier = null,
                @JOBOCCURRENCEID uniqueidentifier = null,
                @DEPARTMENTID uniqueidentifier = null,
                @RANGE int = null,
                @FROM datetime = null,
                @TO datetime = null,
                @REPORTUSERID nvarchar(128),
                @ALTREPORTUSERID nvarchar(128) = null
            )
            as
                set nocount on;

                begin try
                    declare @CURRENTAPPUSERID uniqueidentifier;
                    set @CURRENTAPPUSERID = dbo.UFN_APPUSER_GETREPORTAPPUSERID(@REPORTUSERID, @ALTREPORTUSERID);

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

                end try

                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;