Adding Text to Job History

[cfaulkner]

How would you add text to the job history output? That is the area when you go into the job history and click 'show step detail'. I'd like to log some information here when some of my jobs complete. By default it shows this:

Executed as user: TPL00\sqlservices. Can you hear me now [SQLSTATE 01000] (Message 0). The step succeeded.

...and any error message if the job fails.

Of course I could create a seperate log but why not let SQL Server do some work for me

Thank you for any help!

Craig

 

[cfaulkner]

I can't beleive it...I guess I did it using the print command. 'Can you hear me now' is my text.

I didn't have my coffee this morning...Damn

I anyone has any other ideas or tips for this I'll be listening.

Thanks!

 

[nigelrivett]

e carefull about this because if you add a lot of print statements you can run out of buffer space and lose error messages.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.