Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have scenario

Daily i run a sql job to apply a new updates to one table - this job will create one text file daily - text file contains all new updates

I can send a mail to client that job is successfully completed - now i need to send him a text file as a attachment

Is there any way to send attachment through GUI (SQL Server Job setting)

I cann't run the script

EXEC sp_send_dbmail

I googled for this scenario but no information from GUI END - i could find from only with scripts

share|improve this question
    
Is it due to permissions that you cannot use EXEC sp_send_dbmail? –  Carol Baker West Mar 12 '13 at 10:10
    
Yes and with the running same job i need to send mail confirmation and attachment –  sairam Mar 12 '13 at 10:28
1  
There is no way to send attachment through GUI. If you dont have permissions to execute the sp_send_dbmail then you have to ask your DBA or sysadmin to grant you that permission. –  Kin Apr 11 '13 at 13:22

1 Answer 1

I was looking of for the same issue myself, and gave up. It seems that attachments can only be sent using TSQL, such as this

EXEC sp_send_dbmail 
  @profile_name='MailProfile',
  @recipients='me@gmail.com',
  @subject='TestEmail',
  @body='I'm sending you this document...',
  @file_attachments='D:\TEST\file.doc'
share|improve this answer
    
Thanks for ur answer ,I know it can be done through scripts but i cann't use "EXEC sp_send_dbmail " –  sairam Mar 12 '13 at 10:33
    
@CarolBakerWest -- the script will throw syntax error as the '@body' should have 2 quotes ==> @body='I''m sending you this document...' –  Kin Apr 11 '13 at 13:24

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.