As often as I have to pull a job’s name based on its job_id in the MSDB system tables, I’m truly stunned that I’ve never done this before: CREATE FUNCTION dbo.JobName ( @job_id UNIQUEIDENTIFIER ) /* A little utility function to return a job name based on the job_id. No warranty or guarantee implied. Use at […]
Utility function: dbo.JobName(@job_id)
- Post author By Jen McCown
- Post date
- Categories In Admin, sql server, sqlserverpedia-syndication, SSC, Tips, TSQL
- 2 Comments on Utility function: dbo.JobName(@job_id)