question

Gergav33 avatar image
Gergav33 asked

SQL Server Agent Job Category

Hi,

Just wondering is it possible to Include the Job Category in the output to the event log.

Ger

sql-agentjob
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered

You're pretty limited in what it can output. Within just the regular options, no, you can't. What you could do, and it won't be easy, would be to create output from the step itself that includes information on the Job Category. That would require you to capture that information within the process of the step and then put it into the output from the step and then log the output. Messy and a lot of manual work for each & every step.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.