Sunday, February 26, 2012

Error using CDOSYS in a process

Hi !
I created a backup process that sends me an email (CDOSYS) with the result
of this operation, following the instructions at
http://support.microsoft.com/defaul...;312839&sd=tech
The problem is that the stored procedure sp_send_cdosysmail crashes if it's
run inside a SQL Server 2000 SP3a process (schedule or manual execution is
the same) but it run fine if I use query analyzer to exec the sp. Process
and query analyzer window have a single TSQL instruction (exec...) but the
SQL Server Agent keeps on stopping after a while with an error (I don't
remember the message but it was something like "not responding after 30
secs") if I run the process.
What could it be ? Thank you.
Mauro CastaldiI strongly suggest using CDO within sp_OACreate. Try using xp_smtp_sendmail
instead... http://www.aspfaq.com/2403
http://www.aspfaq.com/
(Reverse address to reply.)
"Mauro Castaldi" <no.spam.kastaldi@.hotmail.com> wrote in message
news:41e10c24$0$8209$5fc30a8@.news.tiscali.it...
> Hi !
> I created a backup process that sends me an email (CDOSYS) with the result
> of this operation, following the instructions at
> http://support.microsoft.com/defaul...;312839&sd=tech
> The problem is that the stored procedure sp_send_cdosysmail crashes if
it's
> run inside a SQL Server 2000 SP3a process (schedule or manual execution is
> the same) but it run fine if I use query analyzer to exec the sp. Process
> and query analyzer window have a single TSQL instruction (exec...) but the
> SQL Server Agent keeps on stopping after a while with an error (I don't
> remember the message but it was something like "not responding after 30
> secs") if I run the process.
> What could it be ? Thank you.
> Mauro Castaldi
>

No comments:

Post a Comment