SQL Server Performance Forum – Threads Archive

DTS jobs

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"

---

Check the job history. It will give you the reason for the failure —————————————-
http://spaces.msn.com/members/dineshasanka

---

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.

---

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.

---

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

---

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"

---

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"

---

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

---

yup I checked it..it shows as following. Executed as user: CWOPAOBSVCSQL01. …ProductionJobsFileTransfers Crogram FilesCommon FilesSystemMapi1033NT>rename EroductionJobsFileTransfersInputsWARRANT 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"

---

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"

---

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"

---

]]>