Job Fail.

Hi,
I have a job that reads from server A and writes the data
in server B. The job is scheduled to run every 5 min. Now
and again, the job fails and I get the following
message: "Incorrect function. [SQLSTATE 42000] (Error
50000). The step failed." but everything is OK for the
next run.
Is it a network problem (between the servers), a server
problem, a Windows problem? I will appreciate any help on
that.
Thankx,Specify an output file for the jobstep and then after next execution look in
that file for error
messages. Also, try View Job History, check "Show Step Details", navigate to
the failed jobstep and
hunt for error messages.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"mona" <anonymous@.discussions.microsoft.com> wrote in message
news:22de301c45d9b$f4e61550$a001280a@.phx
.gbl...
> Hi,
> I have a job that reads from server A and writes the data
> in server B. The job is scheduled to run every 5 min. Now
> and again, the job fails and I get the following
> message: "Incorrect function. [SQLSTATE 42000] (Error
> 50000). The step failed." but everything is OK for the
> next run.
> Is it a network problem (between the servers), a server
> problem, a Windows problem? I will appreciate any help on
> that.
> Thankx,|||I specified an output file and waiting for the next
failure. The error message in my first mail is from
the "view Job History".
How come there is no error number 50000 in the
master.dbo.sysmessages?

>--Original Message--
>Specify an output file for the jobstep and then after
next execution look in that file for error
>messages. Also, try View Job History, check "Show Step
Details", navigate to the failed jobstep and
>hunt for error messages.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"mona" <anonymous@.discussions.microsoft.com> wrote in
message
> news:22de301c45d9b$f4e61550$a001280a@.phx
.gbl...
data[vbcol=seagreen]
Now[vbcol=seagreen]
on[vbcol=seagreen]
>
>.
>|||Ahh, I missed that error number. Error 50000 is what you get if you execute
RAISERROR and pass a
string. So you have to look at your code and see what part executes the RAIS
ERROR command. Remember
that is can be hidden in a trigger or stored procedure.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"mona" <anonymous@.discussions.microsoft.com> wrote in message
news:22bd301c45db6$b1977260$a401280a@.phx
.gbl...[vbcol=seagreen]
> I specified an output file and waiting for the next
> failure. The error message in my first mail is from
> the "view Job History".
> How come there is no error number 50000 in the
> master.dbo.sysmessages?
>
> next execution look in that file for error
> Details", navigate to the failed jobstep and
> message
> data
> Now
> on