sql-server-agent Archives

SQL Server Agent not running SSIS package

September 6, 2022 by Magenaut

I have followed many articles to create an SSIS pipeline package, deploy it and schedule it.
I’m trying to transfer data from two remote servers, an OLEDB driver that connects to a SQL Server Database as a Source and an OLEDB provider for ODBC drivers that connects to a MySQL Database as a Destination…

Why does this query fail when I run it from a SQL Server job?

September 6, 2022 by Magenaut

I know how to solve the issue, but I don’t understand the technicality of why the below query would work when I run it from SSMS, but the same query fails when I add it as a job in the SQL Server agent.