Jul 30, 2013 · You can use msdb.dbo.sysjobs to translate the job_id to a job_name. SET ANSI_NULLS ON. GO. SET QUOTED_IDENTIFIER ON. GO. CREATE FUNCTION [dbo].[GetJobIdFromProgramName] (@program_name...

You will have to use tokens in your job steps to get your own job id. Details here: Using Tokens in Job Steps. At the end of the article there's one example with jobid: SELECT * FROM msdb.dbo.sysjobs WHERE @JobID = CONVERT(uniqueidentifier, $(ESCAPE_NONE(JOBID))) ;

May 31, 2018 · use msdb SELECT [sJOB].[job_id] AS [JobID] , [sJOB].[name] AS [JobName] ,step.step_name ,step.command FROM [msdb].[dbo].[sysjobs] AS [sJOB] LEFT JOIN [msdb].dbo.sysjobsteps step ON sJOB.job_id = step.job_id WHERE step.command LIKE '%MYTABLENAME%' ORDER BY [JobName]

Aug 7, 2013 · Install RedGate SQL Search tool in SSMS. It's free and makes a lot of things a breeze. Here is a query that will give you that and more (look at the WHERE clause for the stored proc name): [sJOB].[job_id] AS [JobID] , [sJOB].[name] AS [JobName] , [sJSTP].[step_uid] AS [StepID] , [sJSTP].[step_id] AS [StepNo] , [sJSTP].[step_name] AS [StepName]

Jul 24, 2016 · SELECT j.name FROM msdb.dbo.sysjobs AS j WHERE EXISTS ( SELECT 1 FROM msdb.dbo.sysjobsteps AS s WHERE s.job_id = j.job_id AND s.command LIKE '%procedurename%' );

Dec 31, 2021 · This article helps you get the SQL Server agent job name from the hexadecimal Job ID format.

May 17, 2007 · you can use @@SPID and get the job name from the master.dbo.sysprocesses.program_name column. If you can parse that value out you can query msdb.dbo.sysjobsview to get the job name

Feb 18, 2021 · You obviously have to work out how to get the ProgramName for the right job into your variable. You can do this easily with sp_WhoIsActive. @get_additional_info = 1, . @get_task_info = 2; If you click on the additional_info column, you'll see this:

Aug 24, 2009 · SELECT sysjobs.name 'Job Name', syscategories.name 'Category', CASE [description] WHEN 'No Description available.' THEN '' ELSE [description] END AS 'Description' FROM msdb.dbo.sysjobs INNER JOIN msdb.dbo.syscategories ON msdb.dbo.sysjobs.category_id = msdb.dbo.syscategories.category_id WHERE syscategories.name <> 'Report Server' ORDER BY ...

Sep 29, 2021 · SELECT job.job_id, NAME, description, command, server, database_name FROM msdb.dbo.sysjobs job INNER JOIN msdb.dbo.sysjobsteps steps ON job.job_id = steps.job_id WHERE job.enabled = 1;