Left join SS on SS.schedule_id = SJ.schedule_id WHEN 4 then 'Every ' + convert(varchar(10),freq_subday_interval) + ' minutes' WHEN 2 then 'Every ' + convert(varchar(10),freq_subday_interval) + ' seconds' 'freq_rel' = CASE(freq_relative_interval) WHEN (freq_type = 32) then (select freq_rel + WDAY WHEN (freq_type = 16) then 'Day ' + convert(varchar(2),freq_interval) 'D7' = CASE WHEN (freq_interval & 64 0) then 'Sat ' ELSE '' END 'D6' = CASE WHEN (freq_interval & 32 0) then 'Fri ' ELSE '' END, 'D5' = CASE WHEN (freq_interval & 16 0) then 'Thu ' ELSE '' END, 'D4' = CASE WHEN (freq_interval & 8 0) then 'Wed ' ELSE '' END, 'D3' = CASE WHEN (freq_interval & 4 0) then 'Tue ' ELSE '' END, 'D2' = CASE WHEN (freq_interval & 2 0) then 'Mon ' ELSE '' END, 'D1' = CASE WHEN (freq_interval & 1 0) then 'Sun ' ELSE '' END, WHEN (freq_type = 8) then (select 'Weekly Schedule' = MIN(D1+ D2+D3+D4+D5+D6+D7 ) WHEN (freq_type = 4 and freq_interval > 1) then 'Every ' + convert(varchar(10),freq_interval) + ' Days' WHEN (freq_type = 4 and freq_interval = 1) then 'Every Day' WHEN (freq_type = 1) then 'One time only' WHEN 32 THEN 'Every ' + convert(varchar(3),SS.freq_recurrence_factor) + ' Months' - RELATIVE WHEN 16 THEN (case when (SS.freq_recurrence_factor > 1) then 'Every ' + convert(varchar(3),SS.freq_recurrence_factor) + ' Months' else 'Monthly' end) WHEN 8 THEN (case when (SS.freq_recurrence_factor > 1) then 'Every ' + convert(varchar(3),SS.freq_recurrence_factor) + ' Weeks' else 'Weekly' end)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |