Scheduled job completion status
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-07-2016 06:22 AM
I have created a scheduled job that runs a script against the CI tables. Is there a way, once I have started the job (by using the Execute Now button) that I can see when the job status? ie running, complete, failed, etc
Ric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-07-2016 06:31 AM
This should show up in the "todays scheduled jobs" module or you can access the schedule table by putting this in the navigator: sys_trigger.list
If you sort by updated you should be able to see your job after clicking execute now.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-07-2016 07:53 AM
Thank you!
Ric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-07-2016 06:31 AM
you can check that from sys_trigger table, but that is only if you want to see as an admin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-21-2020 09:51 PM
You should be able find that in v_cluster_transaction table, Module is Active transaction(All nodes)
The running jobs will be appearing node wise and you may have the option to see the Age and other fields.
You can kill a job from the above module.
NOTE: When you delete a running job from the sys_trigger, it will have an active thread in v_cluster_transaction table,So inorder to stop a job you will have to kill it.