SQL Server Performance

DTS jobs

Discussion in 'SQL Server DTS-Related Questions' started by Reddy, Jan 25, 2006.

  1. Reddy New Member

    Hi.
    I have shedules few jobs on daily basis, all the jobs worked Ok, I come to know this by getting job success mails, which i have set up when creating it as if the job runs without fail shoot a success mail to me. everything looks ok but when i check in the DTS(jobs) section those jobs are in red mark telling that the job failed, It looks weired to me.
    one more thing is we have changed our password for the sql server service account, does this effect in any way.

    Thanks!
    "He laughs best who laughs last"

  2. dineshasanka Moderator

  3. satya Moderator

    If thsoe jobs are being used by SA then make sure you input the same for those DTS packages, as they may fail due to mismatch of password. Also refer to DTS package log for more information.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. Mast_dba New Member

    Hi
    Can u plz tell me how to check the DTS package log & job history.
    Thanks in advance.
    Mast
  5. ranjitjain New Member

    quote:Originally posted by Mast_dba

    Hi
    Can u plz tell me how to check the DTS package log & job history.
    Thanks in advance.
    Mast

    It's better you start your new thread.
    Anyways,
    Open Enterprise Manager.
    Expand your server name.
    Under Management Folder expand SQL Server Agent.
    Click on Jobs which will show you all your jobs on right side
    right click on your job and select view job history option.
    After clicking in opened window check the show step details options.
    This will shows the error if any occurred while running the job.
  6. Mast_dba New Member

    Thanks ranjit for reply. I will keep this in mind next time & open my new thread.
    Thanks
    Mast
  7. Reddy New Member

    My job history shows as "The job failed. The Job was invoked by Schedule 35 (LoadWarrants). The last step to run was step 1 (LoadWarrants)."

    satya recently we changed our service account pswd, how does tht effect and where I need to configure according to the changes made.

    Thanks!
    "He laughs best who laughs last"

  8. Reddy New Member

    Satya.. 1 more thing. when all other jobs which run under SA are working fine except this job, what may be the reason.

    Thanks!
    "He laughs best who laughs last"

  9. ranjitjain New Member

    quote:Originally posted by Reddy

    My job history shows as "The job failed. The Job was invoked by Schedule 35 (LoadWarrants). The last step to run was step 1 (LoadWarrants)."

    satya recently we changed our service account pswd, how does tht effect and where I need to configure according to the changes made.

    Thanks!
    "He laughs best who laughs last"

    Have you checked the option of "show step details" while checking the job history.
    It will show you exact cause for that error
  10. Reddy New Member

    yup I checked it..it shows as following.

    Executed as user: CWOPAOBSVCSQL01. ...ProductionJobsFileTransfers C:program FilesCommon FilesSystemMapi1033NT>rename E:productionJobsFileTransfersInputsWARRANT WARRANT.txt The system cannot find the file specified.DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSFTPTask_1 DTSRun OnFinish: DTSStep_DTSFTPTask_1 DTSRun OnStart: DTSStep_DTSCreateProcessTask_1 DTSRun OnError: DTSStep_DTSCreateProcessTask_1, Error = -2147220330 (80040496) Error string: CreateProcessTask 'DTSTask_DTSCreateProcessTask_1': Process returned code 1, which does not match the specified SuccessReturnCode of 0. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4900 Error Detail Records: Error: -2147220330 (80040496); Provider Error: 0 (0) Error string: CreateProcessTask 'DTSTask_DTSCreateProcessTask_1': Process returned code 1, which does not mat... Process Exit Code 1. The step failed.



    Thanks!
    "He laughs best who laughs last"

  11. Reddy New Member

    I am really frustrated with this DTS job, when all the other jobs are working fine with the same credentials and everything looks same when compared to other jobs, but i cudnt figure out why only this is job is failing to execute according to the shedule. I am running it manually every day. Pls HELP.

    Thanks!
    "He laughs best who laughs last"

  12. Reddy New Member

    Any HELP guys...

    Its kind of weired thing for me..when i run it manually its working fine but my shedules job is failing every night. plssss help i am facing this from last 2 weeks.

    Thanks!
    "He laughs best who laughs last"

Share This Page