Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.
declare @user_name varchar(80) declare @user_email varchar(80) declare @support_name varchar(80) declare @support_email varchar(80) declare @server_name varchar(80) declare @server_smtp varchar(80) declare @message_body varchar(1000) set @message_body = 'Dear ' + @user_name + '\n\nPlease be advised that the most recent attempt to update ' + 'the BranchTargets has failed.' + '\n\nA copy of the errors, named BranchErrors.csv, ' + 'has been placed on the designated network drive and can be opened in Excel. For further ' + 'assistance, please contact ' + @support_name + ' at IT support.' + '\n\n\nMessage sent by: BranchTarget_Update (SSIS upload package)\n\n' exec [CE_Extract].dbo.sp_SQLSMTPMail @vcTo = @user_name, @vcCC= @support_email, @vcSubject = 'BranchTarget Update: Failure! XXX', @vcBody = @message_body, @vcFrom = 'BranchTarget.Update@realpeople.co.za', @vcSMTPServer = @server_smtp, @cSendUsing = '2', @vcPort = '25', @cAuthenticate = '0', @vcSenderName = 'BranchTarget.Update@realpeople.co.za', @vcServerName = server_name
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!