After doing a restart to fix some performance issue on a 2017 SQL Server, couple of jobs (kicking off SSIS package) have been failing, all stuck pending execution state. Same issue persists when I manually start the job or execute the package from SSISDB.
The job is set to run using SQL Agent Service, other jobs running a T-Sql statement have been running fine.
It was a permission issue but still don't understand how and why, no changes were made on the server, I was also unable to deploy SSIS package from VS to SSISDB/Integration Services Catalogue.
Repairing the SQL Server via the installation centre seems to have resolved the issue.