|
List Info
Thread: RE: Sql Server Job problem
|
|
| RE: Sql Server Job problem |
  United States |
2007-06-28 04:59:40 |
|
| So what happens if you drop this email out of the
list?
John Warner
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.sah tct.com>... 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 < john jwarner.com">john jwarner.com>
wrote:
What errors are
reported in the log file?
John Warner
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
--- List Settings ---
http://aspadvice.com/lists/
|
[1]
|
|
|
about | contact Other archives ( Real Estate discussion Medical topics )
|