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.
| 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 advanceAradhya |
|
|
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 MVPhttp://visakhm.blogspot.com/ |
 |
|
|
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 messageCould 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, |
|
|
|
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 thishttp://support.microsoft.com/kb/2699687------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
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 |
|
|
|
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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Job execution status