RE: Sql Server Job problem

-----Original Message-----
From: Saroj [mailto:sarojkumar.sahoogmail.com]
Sent: Thursday, June 28, 2007 5:07 AM
To: aspnetaspadvice.com
Subject: [aspnet] RE: Sql Server Job problem

Hi John

Thank U.

While  i execute the SP directly ,error comes but it works fine.

 

But in the case of job error is as below

/*********************************************************

Executed as user: dbo. Error: sending message [SQLSTATE 01000] (Message 0)  Server response: 550 5.1.1 <tct.com">saroj.sahtct.com&gt;... User unknown  1øw4qa?h:? [SQLSTATE 01000] (Message 0).  The step failed.

/*********************************************************

comes and stopes after the error comes.

 

 

 

 

On 6/27/07, John Warner < johnjwarner.com">johnjwarner.com> wrote:

What errors are reported in the log file?

 

 

John Warner

-----Original Message-----
From: Saroj [mailto:gmail.com" target=_blank> sarojkumar.sahoogmail.com]
Sent: Wednesday, June 27, 2007 6:18 AM
To: aspadvice.com" target=_blank>aspnetaspadvice.com
Subject: [aspnet] Sql Server Job problem

I am sending emails by Stored procedure with help of a job in Sqlserver everyday at 11.30 pm. But the problem is mail is not sent to all the peoples, after sending 19  emails it stops.

And shows me the job is failed .

--
Thanks & Regards
Saroj Kumar Sahoo
Call : +91 - 9971422005 --- List Settings --- http://aspadvice.com/lists/

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.9.6/865 - Release Date: 6/24/2007 8:33 AM

--- List Settings ---
http://aspadvice.com/lists/
 

--
Thanks & Regards
Saroj Kumar Sahoo
Call : +91 - 9971422005 --- List Settings --- http://aspadvice.com/lists/

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.9.10/875 - Release Date: 6/27/2007 9:08 PM