one job most of time runs successfully, but somtimes failed

  • My OS is Windows server 2008 R2 enterprise, and SQL Server is 2008 R2 standard edition,  I created more than half year, It ran without any error before this week, but it failed to run sometime since this week. even if I start SQL Server Agent service using NT SERVICE\MSSQLSERVER or NT SERVICE\SQLSERVERAGENT  account, the case is same ( most time runs ok, but sometimes it is ok)

    how can I do the troubleshooting? thanks !

    You must be logged in to view attached files.
  • Read the full error message. It says something about incorrect number of parameters. Without seeing your code or the message or anything else, I can't tell you what's going on, but I can say, read the error. Understand what it is saying, then figure out where in your code you've gone wrong to cause that error. That's it. Troubleshooting 101. Read the error message.

    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
    The Scary DBA
    Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply