
SQL Server Agent Aufträge
SELECT msdb.dbo.sysjobs.name, msdb.dbo.sysjobschedules.next_run_date, CASE (msdb.dbo.sysjobservers.last_run_outcome) WHEN 0 THEN ‚fehler‘ WHEN 1 THEN ‚Erfolg‘ WHEN 3 THEN ‚Abbruch‘ END AS STATUSTEXT, msdb.dbo.sysjobservers.last_run_date, msdb.dbo.sysjobservers.last_run_time, msdb.dbo.sysjobservers.last_run_duration, msdb.dbo.sysjobs.date_modified, CASE LEN(msdb.dbo.sysjobservers.last_run_duration) WHEN 6 THEN LEFT(CAST(msdb.dbo.sysjobservers.last_run_duration AS VARCHAR(6)),2) + ‚:‘ + […]