Scheduled Job to send email notification if the pending job is greater than 20k

[void0703]

Hi all,

I want to schedule a job to send an email notification when the pending job reach at a certain point for example if pending job is greater than 20k. How can we achieve this.

Thanks.

[rushikeshvartak]

What is 20k ? Do you mean total running jobs above 20000 ?

[void0703]

Yes number of pending tasks 

[rushikeshvartak]

select 'admin' as username, count(*) as totaltasks from arstasks where status=1 group by status having count > 2000

[void0703]

I also want to send a email notification to the admin if the pending task are greater than 20000 for example. How can i achieve this?

[rushikeshvartak]

[void0703]

okay this works but I dont want to run the query manually it must be automatic when the pending job reaches 2000 then it must automatically send the email , how that can be done ?

[rushikeshvartak · Accepted solution]

Scheduled report every 1 hour

[void0703]

Is there any other way to do same ?

[rushikeshvartak]

Only this is way

[Manu269]

@void0703 One of the option could be scheduling the analytics to run after every 30 min and in case it breaches the threshold as part of query you can trigger an email.