Scheduled Job runs multiple times when set to run periodically, instead of running only once.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-11-2019 09:33 PM
I have created a scheduled script to run a discovery process every 1 hour.
However, I see that every hour, this script runs 10-15 times, at the exact same time.
Is this behavior known ? If so, how can I prevent this from happening ?
[TIA]
- Labels:
-
Scripting and Coding

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-11-2019 09:36 PM
Do you want to run only one time per day?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-11-2019 10:41 PM
Actually this is a common behavior I observed across 2 apps. The per-hour was just an example.
If I set the period to 1 hour [periodically] or set one fiexd time of the day [Daily], this happens. It runs multiple times at exact same second.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-11-2019 10:07 PM
Hi Harsh,
If Run is Periodically, the duration between each script execution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-26-2019 11:50 AM
Late response, but I ran into this same problem and the issue turned out to be that every time the scheduled job was updated, a new sys_trigger record was being created.
EDIT: Not sure if this is the case for you, but the reason the old sys_trigger records weren't being deleted is because my table name was too long, and it was getting truncated in the Document field of the sys_trigger table. The system couldn't find the records to delete.