We have SQL Server 2012. We got .dtsx
packages that run just fine. We run them manually and they execute properly, but when they are setup to be executed as SQL Server Job, the job executes successfully (no errors), but the SSIS packages are never executed. Nothing happens.
What would be the case? Permissions on packages are setup on FULL for SQLServerAgent
user and same user is setup to be the owner of that job. Also that same user is setup to be DB admin on server.
Any clues how to resolve this?