Send_Mail

EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'ygmail',
@recipients = 'yykwon@cyberwin.co.kr',
@subject = 'Automated Success Message',
@body = '메일을 받아라',
@body_format = 'text',
@file_attachments = 'c:\test.txt'

용량 수정하기 

msdb.dbo.sysmail_configure_sp 'MaxFileSize' , 10097152

 

-- OLE 기능 사용 수정

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO