List Jobs, Schedules, and Next Scheduled Run datetimes
I have this script in my toolbox to resolve the SQL server scheduled job: select S.name AS JobName, SS.name AS ScheduleName, CASE(SS.freq_type) WHEN 1 THEN 'Once' WHEN 4 THEN 'Daily' WHEN 8 THEN (case when (SS.freq_recurrence_factor > 1) then 'Every ' + convert(varchar(3),SS.freq_recurrence_factor) + ' Weeks' else…
Answered Apr 22, 2021 · 11 Views Read answer →