Good day,
I have an issue I can't seem to resolve. I would love some feedback on how others might have handled this situation.
I need a completed trigger to fire another job. The problem is that I have one job with four triggers. Any thoughts?

Job A has Trigger 1 - When A-1 completes, fire Job B
Job A has Trigger 2 - When A-2 completes, fire Job C
Job A has Trigger 3 - When A-3 completes, fire Job D
Job A has Trigger 4 - When A-4 completes, fire Job E

Another way to look at it...
Job B runs when Job A/Trigger 1 completes.
Job C runs when Job A/Trigger 2 completes.
Job D runs when Job A/Trigger 3 completes.
Job E runs when Job A/Trigger 4 completes.

It can be done wit triggers, however I suggest that a better way is to use the Internal - Job/Task. At the end of job A, jo add this task that calls job B

Alternatively you can use flows. In job A, go to the flows task, and add an OnComplete flow that calls job B.

I like the first one the best. Sometimes you want to run a job manually. Say you only want to only run job A for some reason. If you use triggers or flows, job B will run automatically when job A is done, and it is easy to forget this when the logic is 'hidden'. If you use the first solution, the last task is visible and you can inactivate it if you need to.

Thank you, Thomas

The problem is that Job B is not always next.
The triggers are:


When #1 completes, execute Job B for YTD data
When #2 completes, execute Job C for Last Qtr. data
When #3 completes, execute Job D for QTD data

I think I'm just going to clone Job A and tie Job B, C, & D to Event Trigger from cloned A's