How to use AGENT JOB history logs when you're not sysadmin

Coreysan 1,366 Reputation points

I'm learning how to configure agent jobs for error conditions. I don't have sysadmin rights,
so I don't know a good way to fetch information when a step fails.

Any suggestions?

For example, if I check the box to "log to table," and also check the "include step output in history",
will I get sufficient information? There's also the error logs, but I don't have rights to view them.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,032 questions
4,388 questions
0 comments No comments
{count} votes

Accepted answer
  1. YufeiShao-msft 7,016 Reputation points

    Hi @Coreysan ,

    Not necessarily required Sysadmin, if you have the conditions, you also can be the the following msdb database fixed database roles: SQL Server Agent Fixed Database Roles





    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Erland Sommarskog 88,856 Reputation points

    I think it is better testing than asking us, because we don't know what Agent roles you are member of.

    I think the best is to log to a file, and they you need make sure that both you and SQL Server has rights on the folder where the file is located.

    1 person found this answer helpful.
    0 comments No comments