how to view who created, edited or deleted sql agent job in SSMS?

Question

As title, is there any way to check "who" created, edited and deleted SQL Agent job? Not much important who executed the job.
I already check the below site but it's only for job history and there is no info about who modified and deleted.
https://learn.microsoft.com/ko-kr/sql/relational-databases/system-stored-procedures/sp-help-jobhistory-transact-sql?view=sql-server-ver15

Any comments would be appreciated.

Answer 1

Hi anonymous user,

Welcome to Microsoft Q&A!
SQL Server Audit can help you view these message.
Here is a similar thread: https://learn.microsoft.com/en-us/answers/questions/607538/how-to-create-alert-when-any-job-add-modify-or-del.html
And this link which is mentioned in above thread may be helpful for you.
Have a nice day!

Best regards,
Seeya

---

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.

Answer 2

Just to be clear.

That information does not exist, unless you create an audit to capture the data. There is no way to look into the past.