SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Job execution status		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

shobhaaradhya
Starting Member

35 Posts
Posted - 02/07/2013 :  05:38:16  Show Profile  Reply with Quote
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

India
47173 Posts
Posted - 02/07/2013 :  05:42:10  Show Profile  Reply with Quote
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

35 Posts
Posted - 02/07/2013 :  05:52:25  Show Profile  Reply with Quote
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

India
47173 Posts
Posted - 02/07/2013 :  05:59:15  Show Profile  Reply with Quote
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/
Edited by - visakh16 on 02/07/2013 05:59:32
Go to Top of Page

shobhaaradhya
Starting Member

35 Posts
Posted - 02/07/2013 :  06:20:46  Show Profile  Reply with Quote
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

India
47173 Posts
Posted - 02/07/2013 :  06:25:44  Show Profile  Reply with Quote
try after setting rpc option

exec sp_serveroption LNK_SERVER, 'rpc', 'true'

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000