AutoSys Workload Automation

Expand all | Collapse all

using autosys to start and monitor sql server jobs

  • 1.  using autosys to start and monitor sql server jobs

    Posted 12-22-2015 12:24 PM

    I'm looking for a solution using autosys to monitor sql jobs as following:

    1. kick off sql server jobs
    2. monitor the job status
    3. if the a job failed, restart at the step where it failed
    4. email notification if job failed or not running at, let say 3 am.

    I'd appreciate pointers or example of how to accomplish this.

    Thanks!



  • 2.  Re: using autosys to start and monitor sql server jobs

    Posted 12-22-2015 02:08 PM

    autosys has an SQL plug-in why not just cutover and use it.

    you may need to run the cli to launch the jobs and wait.

    it all depends on what version of autosys you have and what you know etc.

    many things are possible

     

     

    Steve C.



  • 3.  Re: using autosys to start and monitor sql server jobs

    Posted 12-22-2015 02:57 PM

    Steve, could you please elaborate more? I'm 100% new to autosys and was tasked to do this.



  • 4.  Re: using autosys to start and monitor sql server jobs

    Posted 12-22-2015 03:24 PM

    For me to elaborate , I would have to teach you autosys. Perhaps your company should hire a consultant to come in and ramp everyone up on it.

    Otherwise, check the reference guide for SQL command job usage. However it will only help you part way, you really need to understand the product etc.

     

    Hope this helps.

     

    Steve C.



  • 5.  Re: using autosys to start and monitor sql server jobs

    Posted 12-23-2015 03:14 AM

    Steve,

     

    Let's say a sql job has 10 steps, and if step number 6 failed. Can autosys start the job where it failed, which is at step # 6?



  • 6.  Re: using autosys to start and monitor sql server jobs

    Posted 12-23-2015 09:25 AM

    if you broke out the call so that there are 10 autosys jobs then yes.

     

    Steve C.

     

    ======================================

     

    It's all relative; What is normal to one is abnormal to another.

    Remember: Cannibalism is normal to a Cannibal



  • 7.  Re: using autosys to start and monitor sql server jobs

    Posted 12-23-2015 09:38 AM

    Steve,

     

    Can multiple autosys jobs wrapped into a single autosys job? Let's say for my example, 10 autosys job wrapped into 1.

    Any pros/cons doing that?

     

    Thanks!



  • 8.  Re: using autosys to start and monitor sql server jobs



  • 9.  Re: using autosys to start and monitor sql server jobs

    Posted 12-23-2015 03:16 AM

    Thanks for the links, RickR! They are helpful.