- April 17, 2015
- 2 Comments
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
- April 08, 2015
- 0 Comments
Following SQL query help to find all the application responsibilities assigned to a specific user or users with start date and end dates, provided a user name.
Query can be further tweaked to suit to your needs and fetch additional information life user names in detail, responsibility ID other responsibility details.
Query can be further tweaked to suit to your needs and fetch additional information life user names in detail, responsibility ID other responsibility details.
- April 08, 2015
- 0 Comments
