SQL Server Performance

Job Running Error

Discussion in 'General DBA Questions' started by dz0001, Feb 11, 2006.

  1. dz0001 New Member

    I have couple of dts packages and schdeule as jobs running every night, one of them, got error every night, however strangly enough, when I right click on the job and click "Start Job", it is succeeded every time. Check on job history detail not helping much.

    Any idea?

  2. Chappy New Member

    If you go to job history, be sure to click the 'show job steps' checkbox.
    This should introduce new log entries which give the actual error, instead of the generic 'job failed' error
  3. viksar New Member

    Beside if the transaction are running through network call, then it might be issue with network or there might be log file getting filled up as all jobs are running at same time.
  4. dz0001 New Member

    Thanks for your reply. I did check "show job steps". but the thing puzzles me most is why manually running job, everything is fine. Job IS running on network, there are couple of jobs running at the same time. So should I just trunc log file to see what happen tonight.

    I will let you know what happen tonight.
  5. dz0001 New Member

    It seems trunc log file not helping stopping the job failure. Here is show step detail information on failed job, however when I right click on Job, then Start Job, it works fine. If there is bad data, nothing should work no matter how you run the job. I really need some pointer here, thanks again.

    Executed as user: dz0001. ...nStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_4 DTSRun OnStart: DTSStep_DTSDataPumpTask_5 DTSRun OnProgress: DTSStep_DTSDataPumpTask_2; 0 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_2 DTSRun OnStart: DTSStep_DTSOlapProcess.Task_1 DTSRun OnProgress: DTSStep_DTSDataPumpTask_4; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_4; 1731 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1731 DTSRun OnFinish: DTSStep_DTSDataPum... Process Exit Code 6. The step failed.
  6. Chappy New Member

    Could it be a permissions problem?
    What user is the job scheduled to run as ?
    When running it from enterprise manager, I believe it will run as the user you are logged in as

Share This Page