SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Utility function: dbo.JobName(@job_id)

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 … Continue reading Utility function: dbo.JobName(@job_id)

Comments

Leave a comment on the original post [www.midnightdba.com, opens in a new window]

Loading comments...