UFN_SCHEDULE_HASENABLEDSCHEDULES

Returns whether any enabled schedules exist in the database.

Return

Return Type
bit

Definition

Copy



create function dbo.UFN_SCHEDULE_HASENABLEDSCHEDULES()
returns bit
as begin
    declare @RESULT bit = 0;
    select top 1 @RESULT = 1 from dbo.SCHEDULE where ENABLED = 1;
    return @RESULT;
end