Posts in: SQL
ESS - Jobs That Require Review
List ESS jobs that are blocked, on hold, cancelling, or need manual recovery review.
Read More →ESS - High Frequency ESS Schedules
Retrieve ESS scheduled jobs with high-frequency schedules (Minutely).
Read More →ESS - Check Ready Jobs
Retrieve ESS jobs in 'Ready' state which have not started within 1 minute of ready time.
Read More →ESS - Average Completion Run Time Jobs Last Hour
Calculate average run time in seconds for ESS jobs completed successfully in the last 1 hour.
Read More →ESS - Duplicate ESS Jobs in Running Mode
Identify duplicate running ESS jobs where the definition appears more than 20 times.
Read More →