Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Pri
Starting Member
5 Posts |
 Posted - 2008-12-26 : 15:35:47
|
| Hi,I have created a job that has 2 steps step 1 - create Excel file.step - send excel file in email.Both steps gets excuted sucessvily but sometimes I recieve emails and sometimes not. Please help me I am stuck .This is the code for sending emails.EXEC msdb..sp_send_dbmail@profile_name = 'SQLAdminProfile',@recipients = @Usermail,@subject = 'Sourcing Reveune Export File',@file_attachments = '\\bosintranetdev\Reports\Excel\SourcingRevenueExport.xls',@exclude_query_output = 1if @@error = 0Update SendSourceRevenue Set EmailStatus='Y', UpdatedOn=GetDate() where RequestedId = @ResquestId |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Pri
Starting Member
5 Posts |
Posted - 2008-12-26 : 22:20:04
|
| Hi,Maximum size of the file is 7MB. Sometimes I receive the file and sometimes not and If I run StoreProcedure on SQL Query Analyzer then I am able to receive 7 MB file in my email.Please help me I got stuck...Thanks |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Pri
Starting Member
5 Posts |
Posted - 2008-12-27 : 10:16:21
|
| Thanks for your reply.Database mail size limit is 100MB and job is running successfully but I am not receiving emails. Please suggest me how can I resolve this...Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Pri
Starting Member
5 Posts |
Posted - 2008-12-27 : 23:49:44
|
| Ok, but there is no email server and I am writing everthing is store procedure. How do I compress file in Store Proc? What is Email Server and how can I prevent to block it..Thanks fro your help. |
|
|
|
|
|
|
|
|
Problem in running JOB - Sending Email