Alert scheduled for below mentioned time.

[m7787580]

HI Team,

Is it possible i can get the report scheduled for below mentioned time.

Could we get a report at 9:00am and then another at 2:00pm. The first would cover data from 2:00pm to 9:00am and the second from 9:00 to 2:00pm.
1.--> 2:00pm to 9:00am --19hrs
2.-->9:00 to 2:00pm --5 hrs

1 possible option is to create two alerts and schedule it but i dont what would be cron job.

Could you please help.

Thanks in advance

[richgalloway · Accepted solution]

The cron part is easy. Schedule the alert using 01 9,14 * * * to run the alert at 9:01 am and 2:01 pm.
The harder part is telling the alert to search the previous 19 hours on the first run of the day and the previous 5 hours on the second run of the day. For that, I think you'll need two alerts.

[m7787580]

Thanks, I have created two alerts