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"