Credits:
Author: Solihin Ho
Date: 18 May 2009
Description
Decodes the integer bitmap represneation ised in MSDB for job frequency interval into a string
eg 65 => 'Saturday, Sunday'
Code
Function:
|
DROP FUNCTION dbo.udf_DecodeJobFequencyInterval
GO
CREATE FUNCTION udf_DecodeJobFequencyInterval(@freq_interval INT)
RETURNS VARCHAR(1000)
/*************************************************************
Purpose: Takes a an integer representing MSDB job frequency
and decodes it into a description string (one or many days)
Author: Solihin Ho
History: 18 May 2009
***************************************************************/
AS
BEGIN
DECLARE @result VARCHAR(1000)
SET @result = ''
IF (@freq_interval & 1 = 1)
SET @result = 'Sunday, '
IF (@freq_interval & 2 = 2)
SET @result = @result + 'Monday, '
IF (@freq_interval & 4 = 4)
SET @result = @result + 'Tuesday, '
IF (@freq_interval & 8 = 8)
SET @result = @result + 'Wednesday, '
IF (@freq_interval & 16 = 16)
SET @result = @result + 'Thursday, '
IF (@freq_interval & 32 = 32)
SET @result = @result + 'Friday, '
IF (@freq_interval & 64 = 64)
SET @result = @result + 'Saturday, '
RETURN(LEFT(@result,LEN(@result)-1))
END
-- select dbo.udf_DecodeJobFequencyInterval (65)
-- select dbo.udf_DecodeJobFequencyInterval (39)
|
