The following query find the currently running jobs/concurrent programs in the application along with the date and time details. It's a very useful query which provide the Request ID, Program name and provided the start date and time in the required format.
Output will be in one column under CURRENTLY_RUNNING_PROGRAMS with results like -
Request_ID 7746467 (Program Name) has been running since 2015-04-08 14:20:31
