open v_cur
fetch next from v_cur into @v_ ...
while @@fetch_status = 0
begin
...
exec msdb..sp_send_dbmail
@profile_name   = @v_profile
, @recipients   =  @v_recipients 
, @subject      = @v_subject
, @body         = @v_body 

fetch next from v_cur into @v_ ...
end

SELECT retries_attempted cnt1 
, run_date d1 , run_time tm1
, MESSAGE M1
     , *
  FROM msdb.dbo.SYSJOBHISTORY
  WHERE job_id = (
    SELECT job_id
    FROM msdb.dbo.sysjobs
    WHERE name = 'suspend_data_processing'
			)
--    AND run_date = 20140724
AND CHARINDEX ( '(5401199)' , MESSAGE ) != 0
  AND step_id =2
  ORDER BY instance_id DESC;

SELECT sent_date dat1
, send_request_date d2
,  a.mailitem_id m_id
, b.description err_descr
, sent_status 
, sent_account_id
, subject subj
--, from_address from1
, * 
FROM msdb.dbo.sysmail_mailitems a
	LEFT join msdb.dbo.sysmail_log B
		on B.mailitem_id = a.mailitem_id
where
1=1
--and send_request_date > sent_date
and profile_id != 2
and sent_date >= '2014-08-21'
order by  sent_date  desc