Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Job execution status

Author  Topic 

shobhaaradhya
Starting Member

37 Posts

Posted - 2013-02-07 : 05:38:16
Hi,

I have number of jobs running. One of the job is failing and shows the status "Between entries". What does it mean.

Is there any way where I can get more information why the job is failing?

Thanks in advance
Aradhya

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-07 : 05:42:10
probably you mean Between retries.
That happens when job has definite retries defined in its properties and when it tries to retry the execution upon failure

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

shobhaaradhya
Starting Member

37 Posts

Posted - 2013-02-07 : 05:52:25
Hi sorry,

Its Between retries.

when the job failed I looked into the history on one of the latest failure its giving message

Could not create an acceptable cursor. [SQLSTATE 42000] (Error 16955) OLE DB provider "SQLNCLI" for linked server "LNK_SERVER" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". [SQLSTATE 01000] (Error 7412). NOTE: The step was retried the requested number of times (5) without succeeding. The step failed.

Any idea what does this message means?

Thanks,
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-07 : 05:59:15
yep. it means SQL Agent tried 5 times executing the job and all times it failed due to error in connecting to linked server LNK_SERVER.

Reason can be this

http://support.microsoft.com/kb/2699687

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

shobhaaradhya
Starting Member

37 Posts

Posted - 2013-02-07 : 06:20:46
Hi,

I checked the url. But the table from the linked server does not have any datetime datatype.

Any idea?

Thanks,
Aradhya
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-07 : 06:25:44
try after setting rpc option

exec sp_serveroption LNK_SERVER, 'rpc', 'true'

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -