x

SQL Server Agent Job Category

Hi,

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

Ger

more ▼

asked Feb 04, 2010 at 10:51 AM in Default

Gergav33 gravatar image

Gergav33
61 4 4 4

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Feb 04, 2010 at 11:00 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x91
x87

asked: Feb 04, 2010 at 10:51 AM

Seen: 1276 times

Last Updated: Feb 04, 2010 at 10:51 AM