I'm looking for a solution using autosys to monitor sql jobs as following:
I'd appreciate pointers or example of how to accomplish this.
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, could you please elaborate more? I'm 100% new to autosys and was tasked to do this.
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.
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?
if you broke out the call so that there are 10 autosys jobs then yes.
It's all relative; What is normal to one is abnormal to another.
Remember: Cannibalism is normal to a Cannibal
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?
Some Links to check:
CA Workload Automation Agent for Microsoft SQL Server r11.3.1
Thanks for the links, RickR! They are helpful.