UFN_JOBSCHEDULE_DATEVALID2

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@DT	datetime	IN
@OCCURRENCETYPE	tinyint	IN
@STARTDATETIME	datetime	IN
@STARTMONTHDAY	datetime	IN
@ENDDATETIME	datetime	IN
@ENDMONTHDAY	datetime	IN

Definition

Copy



                create function dbo.UFN_JOBSCHEDULE_DATEVALID2(@DT datetime, @OCCURRENCETYPE tinyint, 
                                        @STARTDATETIME datetime, @STARTMONTHDAY datetime, 
                                        @ENDDATETIME datetime, @ENDMONTHDAY datetime) 
                    returns bit with execute as caller
                    as 
                    begin
                        declare @retval as bit;
                        declare @MONTH as int;
                        declare @DAY as int;

                        if @dt is null  
                            return 0;

                        if @OCCURRENCETYPE = 2 --ongoing

                            return 1;

                        if @OCCURRENCETYPE = 0 --onetime

                            if @dt between @STARTDATETIME and @ENDDATETIME
                                return 1;

                        if @OCCURRENCETYPE = 1 --recurring                    

                            if @DT between @STARTMONTHDAY and @ENDMONTHDAY
                                return 1;

                return 0;
                    end