Scheduled job completion status

[rhofing]

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

[Umar M]

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.

[rhofing]

Thank you!

Ric

[Anurag Tripathi]

you can check that from sys_trigger table, but that is only if you want to see as an admin

[Adarsh Krishnam]

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.