AutoSys Workload Automation

 View Only
  • 1.  AutoSys vs SQL Agent

    Posted Aug 03, 2018 09:15 AM

    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?



  • 2.  Re: AutoSys vs SQL Agent

    Posted Aug 05, 2018 03:34 AM

    dtexec is supposedly the preferred command line to run SSIS package?