durai nagarajan (10/10/2012)

---

can you provide the below details.

are using excel to open the csv file?

what is the sql server and office version?

approximate no of rows for 2 or 3 days

Bhuvnesh (10/10/2012)

---

is it started happeinig at sudden ?
and
are you using same location for CSV file by both the job and manual process? because there could be space issue

mahesh.dasoni (10/11/2012)

---

use this in the job step while executing


EXEC MSDB.DBO.SP_SEND_DBMAIL
@PROFILE_NAME = @MPOFILENAME,
@RECIPIENTS = @MRECIPIENTS,
@COPY_RECIPIENTS = @MRECIPIENTS_CC,
@QUERY = @MQUERY,
@SUBJECT = @MPROFILEDESC,
@attach_query_result_as_file = 1,
@query_attachment_filename = 'myfile.csv'

mahesh.dasoni (10/11/2012)

---

use this in the job step while executing


EXEC MSDB.DBO.SP_SEND_DBMAIL
@PROFILE_NAME = @MPOFILENAME,
@RECIPIENTS = @MRECIPIENTS,
@COPY_RECIPIENTS = @MRECIPIENTS_CC,
@QUERY = @MQUERY,
@SUBJECT = @MPROFILEDESC,
@attach_query_result_as_file = 1,
@query_attachment_filename = 'myfile.csv'