extended property state change.sql

DECLARE @timeupdated NVARCHAR(256);
SELECT @timeupdated = CAST(SYSDATETIME() AS NVARCHAR);
IF
(
    SELECT COUNT(*)
    FROM fn_listextendedproperty('Most recent job update', DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT)
) = 0
BEGIN
    EXEC sp_addextendedproperty @name = N'Most recent job update',
                                @value = @timeupdated;
END;
ELSE
BEGIN
    EXEC sp_updateextendedproperty @name = N'Most recent job update',
                                   @value = @timeupdated;
END;