Job Fails When Run Automatically

Question

Job Fails When Run Automatically

cdun2

SSCertifiable

Points: 7893
More actions
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

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

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

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

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

cdun2 SSCertifiable Points: 7893 More actions · Answer 2

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

CSDunn

Sreejith Sreedharan SSCertifiable Points: 5403 More actions · Answer 3

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

mrivera Ten Centuries Points: 1050 More actions · Answer 4

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.