question

I was assigned a task to automate a notification alert to inform managers to send checklist of terminated employee to security admin within 5 business days of effective termination of employee(s). Below is the stored procedure to be modified to perform this task. Please, I am baby developer. I need assistance as to developing the right code to do the job. CREATE PROCEDURE [dbo].[sp_TerminationChecklist] AS Declare @Rec_Count int select @Rec_Count=count(*) from employee where TerminationDate>dateadd(dd,-1,getdate()) if @Rec_Count=0 EXEC master.dbo.xp_sendmail @recipients = 'TerminatedEmployeeManager', @message = 'There were no terminations for the previous workday', @width =355, @copy_recipients = 'aa12', @subject = ' DatabaseName - List of terminated employees', @dbuse = 'DatabaseName' else EXEC master.dbo.xp_sendmail @recipients = 'TerminatedEmployeeManager', @message = 'Please, send checklist of Terminated Employees to Security Admin with 5 day of effective termination of employee ', @query = 'select TerminationDate,EmpFirstName, EmpLastName,lanid from tblemployee where DateTerminated>dateadd(dd,-1,getdate()) order by DateTerminated desc', @width =355, @copy_recipients = 'aa12', @subject = ' DatabaseName - List of terminated employees', @dbuse = 'DatabaseName'