SQL Server Performance

Job Fails

Discussion in 'SQL Server DTS-Related Questions' started by chaitanya, Jun 12, 2007.

  1. chaitanya New Member

    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
  2. MichaelB Member

    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!"
  3. chaitanya New Member

    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
  4. MichaelB Member

    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!"

Share This Page