Failed sql jobs

Configurare noua (How To)

Situatie

Mai jos aveti o procedura care returneaza joburile de sql ce au dat eroare la ultima executie pe un server.

Solutie

create FailedJobs_prc

as

select
h.server as [Server],
j.[name] as [Name],
h.message as [Message],
h.run_date as LastRunDate,
h.run_time as LastRunTime

from sysjobhistory h
join sysjobs j on h.job_id = j.job_id

where j.enabled = 1
and h.instance_id in
(
select max(h.instance_id)
from sysjobhistory h
group by (h.job_id)
)
and h.run_status = 0

Tip solutie

Permanent
Etichetare:

Voteaza

(8 din 16 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?