SQL Server suspending jobs - Error 0x80131904

0

I have an SSIS package which runs fine in debug mode from Visual Studio, however if It runs as a SQL Server job it hangs at step 2 which takes about twenty minutes in Visual Studio. The only thing I can think it could be is the SQL Server job itself.

The shutdown interval is set to 15 seconds in the SQL Server Agent. Could that cause the job to suspend?

Any help appreciated.

sql-server
ssis
asked on Stack Overflow Dec 2, 2020 by Christopher Jack • edited Dec 2, 2020 by Christopher Jack

1 Answer

0

Thanks to everyone who helped. I created a new Job on the SQL Server and the package seems to be running fine.

answered on Stack Overflow Dec 2, 2020 by Christopher Jack

User contributions licensed under CC BY-SA 3.0