Job Fails | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Job Fails

Hi, I have a job that is scheduled to run every day. The job used to run fine untill recently when i noticed that it failed. The tried to run the job manually and it worked fine but i don’t understand why the job failed keeping into consideration that nothing change from the moment it failed to the time i executed the job. DTSRun: Loading… Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: The transaction has exceeded the allotted time. Error source: Help file: C:program FilesCommon FilesMicrosoft SharedRepostryREPOSTRY.CHM Help context: 4164. Process Exit Code 1. The step failed. Thanks,
Chaitanya
You must be having some table growth. I would look at the tables involved and try to increase speed of the query. I would look at the history to see how long it ran when it failed and how long it ran when it didnt fail and compare. It could be something new was running when that happened and caused it to run slower than normal. any new jobs? Mike Michael
MCDBA "The statistics on sanity are that one out of every four persons is suffering from some sort of mental illness. Think of your three best friends — if they’re okay, then it’s you!"
I feel that the problem in my case can be because of two reasons 1. My job gets the data from a remote server and pumps it into my local database. So there can be a situation in which my remote server is busy with something else there by slow to respond which can be one of the reason for timing out. 2. I just check by database size and it looks like i need to increase the size to a threshold value that prevent it from growing at runtime.
Thanks MikeEBS your suggestion definetely brought me close to the solution. Chaitanya
Chaitanya,<br /><br />You are welcome. Glad to help<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br /><br />Michael <br />MCDBA<br /><br />"The statistics on sanity are that one out of every four persons is suffering from some sort of mental illness. Think of your three best friends — if they’re okay, then it’s you!"
]]>