SQL agent job failed with an error 0x80131904

0

I have one SQL agent job that executing the SSIS package. When the job is running through schedule then it is giving an error:

Failed to execute IS server package because of error 0x80131904. Server: XXXXX Package path: "XXXX" Environment reference Id: 2. Description: The operation failed because the execution timed out.

But when I manually running the job by right clicking on it then the job runs successfully.

Could anyone help me on this to find out the root cause and solution of the issue.

Thank you so much in Advance!!

sql-server
sql-server-2008
sql-server-2008-r2
sql-server-2016
sql-agent-job
asked on Stack Overflow Nov 15, 2018 by Shubham Agarwal • edited Nov 15, 2018 by Shubham Agarwal

1 Answer

1

Problem is that SQL Agent Service user don't have rights to execute package.

Two solutions:

  1. Change SQL Server Agent service user read where sql management studio

  2. Make a proxy account for SQL Agent JOB Step ssis proxy account

Go for the 2, because if You have more than one JOB or some policies.....

answered on Stack Overflow Nov 15, 2018 by Justin

User contributions licensed under CC BY-SA 3.0