Converting job_id to join to another table.

Question

Converting job_id to join to another table.

Viewing 3 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 1

Brandie Tarvin wrote:

And after changing my search terms in Google to "SQL Server get job name from sp_who2 program_name" instead of something more generic, I HAVE FOUND IT!
CONVERT(VARCHAR(34),master.dbo.fn_VarbinToHexStr(sj.Job_ID))

Be careful here, the function fn_VarbinToHexStr is an old relic with some rather ugly code, I would not use it in any production code.

😎

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 2

Yet another duplicate post.

😎

This reply was modified 7 months, 3 weeks ago by Eirikur Eiriksson.

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 3

Eirikur, I ended up using Kaj's solution, which didn't require the function.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.