IF NOT EXISTS
(select 1

from msdb.dbo.sysjobhistory jh inner join msdb.dbo.sysjobs j on j.job_id = jh.job_id
where DATEADD (ss, (jh.run_duration/10000 * 3600) + 
  (jh.run_duration/100 %100 * 60) + 
   jh.run_duration %100, + 
 CAST(CAST(jh.run_date AS char(8)) + ' ' +  -- Convert run_date to DateTime data type
         STUFF(STUFF(                          -- Insert : into Time
          RIGHT('000000' +                     -- Add leading Zeros
CAST(jh.run_time AS varchar(6))  ,6)  , 3, 0, ':'), 6, 0, ':') AS datetime)     ) 
     > dateadd (dd,-1,getdate())

and j.name = 'DBA-Job that sometimes Hangs'
and jh.step_id = 0
)
BEGIN
EXEC msdb.dbo.sp_send_dbmail 
 @profile_name = 'Default',
 @recipients = 'me@company.com',
 @subject = '*** ALERT - Archive SPT Logs Not Finished ****',
 @body = 'Check SERVER and see why the job DBA-Job has not finished' ;

END