Send Email with attachment using SQL Server Job Schedular

Question

Hello AllI m following the below link to send automated email on Birthday from sql server agentAutomated Email Notifications using SQL Server Job SchedularIm trying to acheive a slight different reqirement suppose there are 10 persons birthday on any given day i want them to send their details to HR dept in a single email as attachment instead of sending seperate emails for each employeeMeans something to send the records as attachment in email through sql agentis there any way to acheive

pandeyism · Accepted Answer

Hi nadeem1218Please refer below links httpswwwbrentozarcomarchive201410sendqueryresultssqlserveragentjobhttpsdbastackexchangecomquestions99326spsenddbmailstoredproceduresendwithattachmenthttpsstackoverflowcomquestions24750550sendamailfromsqlserverwithattachmentattachmenttobeformeddynamicall

nadeem1218 · Answer

Hi PaandeyismThanks for your support I found a solution instead of sending the results as attachment Im sending them as html email Below is my code CREATE TABLE Temp    EmpId  int  Name  varchar200  Department varchar200  DaysCompleted  varchar128DECLAREoutdesc VARCHAR1000outmesg VARCHAR10count intINSERT INTO Tempselect EMPIDNAMEdeptname DATEDIFFDJOINDATEGETDATE as dayscompleted from  Employee where DATEDIFFDJOINDATEGETDATE85if ROWCOUNT0BeginDECLARE xml NVARCHARMAXDECLARE body NVARCHARMAXSET xml  CAST SELECT EmpId AS 39td393939Name AS 39td393939 department AS 39td393939 DaysCompleted AS 39td39FROM Temp ORDER BY DaysCompleted desc FOR XML PATH39tr39 ELEMENTS  AS NVARCHARMAXSET body 39lthtmlgtltbodygtDear HR DepartmentltbrgtltbrgtThe Below Employees are nearing prohibition periodltbrgtltbrgtlttable border  1

Send Email with attachment using SQL Server Job Schedular

Automated Email Notifications using SQL Server Job Schedular

Company

Explore

Follow us

Contact Us