SSIS 2017 stopped running, not status is Pending Execution

• ConnieD

  SSC Enthusiast

  Points: 172

  More actions

  October 28, 2020 at 3:44 am

  #3801946

  We have 3 sql agent jobs that are running SSIS packages.  Until this past Saturday these have been running wonderfully.  However, now they stop with a Pending Execution status.  Even if I just run the SSIS alone it gives the same status.

  I have restarted the services.  Restarted the server.  Made sure SSIS and SQL Agent is running with correct credentials.

  Any ideas of what could cause this out of the blue and to all 3 at the same time?

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  October 29, 2020 at 4:10 am

  #3802320

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• GroverVivek

  SSCommitted

  Points: 1676

  More actions

  October 29, 2020 at 7:38 am

  #3802353

  Hi,

  From Integration Service Catalog, you can see the execution report of all SSIS packages. You might get error details from there if any.

  Regards
  VG