I try the script but with this part of code I have an error : "Error converting data type nvarchar to varbinary."
select@Job_id = Job_id
--@Job_name = [name] --AS job_name
fromsys.dm_exec_sessions AS ions
inner join msdb.dbo.sysjobs AS jobs on jobs.job_id
= Cast(Convert(binary(16), SUBSTRING(ions.[program_name],CHARINDEX('(Job 0x',ions.[program_name],1) + 5 , 34),1) as uniqueidentifier)
shame on my testing skills. please wait for a revised code that is going to include 2 filters
AND [program_name] is not null
AND CHARINDEX('(Job 0x',ions.[program_name],1) > 0
Comments posted to this topic are about the item Getting Informative SQL Agent Notifications from Failed SSIS Packages
everything should be working now.
Viewing 5 posts - 1 through 4 (of 4 total)