November 23, 2020 at 1:42 pm
error
November 24, 2020 at 8:48 am
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)
November 25, 2020 at 12:01 am
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
November 25, 2020 at 6:27 pm
Comments posted to this topic are about the item Getting Informative SQL Agent Notifications from Failed SSIS Packages
December 4, 2020 at 8:47 pm
everything should be working now.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply