1. we have a job which is waiting on file dependency even after its dependency is met. So to ensure that the jobs are completed on time we need a email action to be triggered when the job is waiting on dependency for more than specific period of time (30 minutes).
2. we wonder why the job is waiting on dependency even after the job dependency is met. Is there any solution to solve this issue?
1. As soon as dependencies are met then job should fire off automatically. But in your case, that may not always be true. While there isn't an event to detect if a job is waiting on dependency for a specified time, you can utilize either 'Job Not Ready by Start Time' or 'Job Not Ready by End of its Time Window'
2. Which Tidal version are you using? Earlier, I had a similar issue with 220.127.116.11, where the job option to re-run whenever dependencies have been met did not work properly. The solution is to either rollback to 77 or patch to 91.