작업스케줄한눈에보기
SELECT [jobs].name as [jobname] , description , CASE convert(nvarchar(3),[sSCH].[enabled]) WHEN 1 THEN 'Y' WHEN 0 THEN 'N' END AS [IsEnabled] , CASE WHEN convert(nvarchar(3),[freq_type],3) = 64 THEN 'SQL Server 시작 시 마다' WHEN convert(nvarchar(3),[freq_type],3) = 128 THEN '서버가 유휴 할때마다' WHEN convert(nvarchar(3),[freq_type],3) IN (4,8,16,32) THEN '되풀이' WHEN convert(nvarchar(3),[freq_type],3) = 1 THE..
2023. 10. 5.