Post reply

Job Fails When Run Automatically

  • August 31, 2006 at 2:45 pm

    #172343

    Hello,

    I am trying to help a user that created a Job. The job runs a DTS package. When the user manually executes the Job, the Job runs fine (the DTS package executes without problems).

    When the Job runs automatically per the configured scedule, the job fails. In the Job history, the following appears;

    'DTSTask_DTSCreateProcessTask_2':  Process.  The step failed.

    What can I do to begin to troubleshoot so that I can figure out why the DTS package fails when executed by a Job (automatically)?

    Thanks!

    CSDunn

  • August 31, 2006 at 2:50 pm

    #657927

    Enable package logging and look at the log after the job runs as scheduled.  The problem is probably permissions because scheduled jobs are run under the security context of the login account that runs SQL Server Agent.  When the user manually runs the job, it runs under his or her security context.

    Greg

    Greg

  • August 31, 2006 at 3:30 pm

    #657933

    Thank you for your help. I will check into this.

    CSDunn

  • August 31, 2006 at 4:04 pm

    #657936

    If possible Terminal into the Server or Logon to the server with the account that SQL Agent uses and try running it manually that will tell you what kind of permission issues that SQL Agent account has.

    Thanks

    Sreejith

  • September 1, 2006 at 10:45 am

    #658091

    You can use EM to get more info on the reason of the failure. In Enterprise Manager go to SQL Agent-> Jobs. Right-click on the failing job, choose 'View Job History' and check the box 'Show step details'. That will tell you in what step and why it failed.

Viewing 5 posts - 1 through 4 (of 4 total)

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