Dlaczego job SQL Server Agent zakończył się błędem? Diagnostyka krok po kroku

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14

SELECT TOP (100)
    j.name AS JobName,
    msdb.dbo.agent_datetime(h.run_date, h.run_time) AS RunDateTime,
    h.step_id,
    h.step_name,
    h.run_status,
    h.sql_severity,
    h.sql_message_id,
    h.message
FROM msdb.dbo.sysjobhistory AS h
INNER JOIN msdb.dbo.sysjobs AS j
    ON h.job_id = j.job_id
WHERE j.name = N'TwojJob'
ORDER BY h.instance_id DESC;

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18

SELECT
    j.name AS JobName,
    s.step_id,
    s.step_name,
    s.subsystem,
    s.database_name,
    s.command,
    s.retry_attempts,
    s.retry_interval,
    s.on_success_action,
    s.on_fail_action,
    s.proxy_id,
    s.output_file_name
FROM msdb.dbo.sysjobsteps AS s
INNER JOIN msdb.dbo.sysjobs AS j
    ON s.job_id = j.job_id
WHERE j.name = N'TwojJob'
ORDER BY s.step_id;

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17

SELECT
    j.name AS JobName,
    SUSER_SNAME(j.owner_sid) AS JobOwner,
    s.step_id,
    s.step_name,
    s.subsystem,
    p.name AS ProxyName,
    c.name AS CredentialName,
    c.credential_identity
FROM msdb.dbo.sysjobs AS j
INNER JOIN msdb.dbo.sysjobsteps AS s
    ON j.job_id = s.job_id
LEFT JOIN msdb.dbo.sysproxies AS p
    ON s.proxy_id = p.proxy_id
LEFT JOIN sys.credentials AS c
    ON p.credential_id = c.credential_id
WHERE j.name = N'TwojJob';

1
2
3
4
5

SELECT
    name AS JobName,
    SUSER_SNAME(owner_sid) AS JobOwner
FROM msdb.dbo.sysjobs
WHERE name = N'TwojJob';