CREATE procedure [dbo].[find_refs]
	@text varchar(250),  
	@dbname varchar(64) = null  
AS begin
	set nocount on
	-- Назначение: Процедура возвращает все объекты в которых прсутствует подстрока
	-- Description: Search a text in stored procedure source code.  
	-- @text - any text to find, search is done by like '%text%'  
	-- @dbname - database where to search,   
	--         - if omitted, all databases in the SQL server instance  
 
	if @dbname is null begin  
		--enumerate all databases.  
		declare #db CURSOR FOR Select Name from master..sysdatabases where  name not in ('tempdb', 'Northwind') and [status] <> 536
		declare @c_dbname varchar(64)  
		OPEN #db FETCH #db INTO @c_dbname  
		while @@FETCH_STATUS <> -1 --and @MyCount < 500  
		begin  
			execute find_refs @text, @c_dbname  
			FETCH #db INTO @c_dbname  
		end    
		CLOSE #db DEALLOCATE #db  
	end 
	else begin   
		declare @sql varchar(250)  
		--create the find like command  
		select @sql = 'select ''' + @dbname + ''' as db, o.type, o.name, c.[text] '
		select @sql = @sql + 'from ' + @dbname + '..syscomments c (nolock) '
		select @sql = @sql + 'join ' + @dbname + '..sysobjects o (nolock) on o.id= c.id '
		select @sql = @sql + 'where c.[text] like ''%' + @text + '%'''  
		execute (@sql)  
	end 

end  

SELECT _jobs.name 
FROM msdb.dbo.sysjobsteps AS _steps
JOIN msdb.dbo.sysjobs AS _jobs
    ON _jobs.job_id=_steps.job_id
WHERE _steps.command LIKE '%sp_SALES_FULL%'