AutoSys vs SQL Agent
We are using SQL 2014, and have around 250 SQL Agent jobs. The vast majority are running SSIS packages, and this runs on a separate server from the data. I've been asked to determine if we would gain anything by moving the scheduling aspect of SQL Agent to AutoSys. We would still use SQL Agent as a container for jobs, and AutoSys for the scheduling.
Our AutoSys environment is 11.3.6.SP7.1589. Also, our AutoSys environment does not use the advanced job types that are now available. Only Box and Command jobs are available for us.
Does anyone have experience with SQL Agent? Specifically, any advantages of using AutoSys for scheduling over native SQL Agent scheduling?