Hello, I would like to stop the SQL Server Agent on our ETL box while a 3rd party is updating their software database that contains most of our transaction data. I have run a test on our Test ETL server to see if it is possible to run a job using sp_start_job while the SQL Agent is stopped. I get the 22022 error about SQL Agent not being notified of the action but does this mean the job didn't run or it just wasn't able to log the activity? I know I have the option of manually executing packages from my machine to accomplish the same results but I consider this a "learning opportunity" as in 20+ years of experience, I have not had to do something as drastic as shut down the SQL Server Agent AND still run a few packages. Out of 100s of jobs, there are only a half dozen or so that must run due to compliance - Medicare/Medicaid....
SQL Server Version: 2016 (13.0.5366.0), Windows 2012 R2 and Package version 2016
Thanks for your advice!