You have a Microsoft SQL Server 2022 instance. You need to troubleshoot failing SQL Agent Jobs. Which command should you run?

The correct answer is D. EXEC sp_read_error_log. sp_readerrorlog (Transact-SQL) allows you to read the contents of the SQL Server or SQL Server Agent error log file and filter on keywords. https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp- readerrorlog-transact-sql?

Submitted by mateo_ar· Mar 6, 2026Perform administration by using T-SQL

Question

You have a Microsoft SQL Server 2022 instance. You need to troubleshoot failing SQL Agent Jobs. Which command should you run?

Options

AEXEC sp_trace_setfilter
BEXEC sp_help_jobserver
CEXEC sp_help_jobsteplog
DEXEC sp_read_error_log;

How the community answered

(43 responses)

A
2% (1)
B
2% (1)
D
95% (41)

Explanation

sp_readerrorlog (Transact-SQL) allows you to read the contents of the SQL Server or SQL Server Agent error log file and filter on keywords. https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp- readerrorlog-transact-sql?

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice