Post reply

Jobs running DTS packages suddenly stopped working

  • March 3, 2011 at 4:26 am

    #247555

    Hi,

    Yesterday our SQL Server (2008 R2) crashed whilst trying to Index a large table.

    This stopped people being able to connect to it.

    We restarted the SQL and SQL Agent services and people were able to connect again.

    Unfortunately since then all of our Jobs that run DTS packages have failed. The ones running SSIS packages work fine.

    The error message we get is

    "The process could not be created for step 1 of job 0xjobid (reason 2)"

    Just to re-itterate the packages have been working fine for months so something must have changed.

    We have tried rebooting the box and services several times.

    Thanks!

  • March 3, 2011 at 4:56 am

    #1293919

    What does the step 1 do?

    If possible, could you also add an error log to the job step so that we could see more descriptive errors

    when the DTS job fails again.

    M&M

  • March 3, 2011 at 4:58 am

    #1293921

    Dug Fazzani (3/3/2011)

    Hi,

    Yesterday our SQL Server (2008 R2) crashed whilst trying to Index a large table.

    This stopped people being able to connect to it.

    We restarted the SQL and SQL Agent services and people were able to connect again.

    Unfortunately since then all of our Jobs that run DTS packages have failed. The ones running SSIS packages work fine.

    The error message we get is

    "The process could not be created for step 1 of job 0xjobid (reason 2)"

    Just to re-itterate the packages have been working fine for months so something must have changed.

    We have tried rebooting the box and services several times.

    Thanks!

    try this USE msdb ;

    GO

    EXEC dbo.sp_update_job

    @job_name = N'your job name'

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • March 3, 2011 at 4:59 am

    #1293923

    Also try to give manual run to that SSIS package

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • March 3, 2011 at 5:05 am

    #1293927

    Thanks guys

    There are 20 packages in question - all of them DTS ones

    The 40 or so SSIS ones run ok

  • March 3, 2011 at 6:24 am

    #1293961

    I've tried the above sp_update_job on one of them and no luck.

    Any other ideas please?

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply