by Israr Ahmed
The following SQL can be used to look at the Batch Simulation Definitions that have been set up. This is the set up ( in Operations Manager à Services à Batch Simulation ) that links together :
- Portfolio (query )
- Batch Simulation ( which contains the sim results )
- Reval Type ( what reval type to save as )
The Batch Simulation Definitions are then referred to in the run scripts when running in the End Of Day Workflows.
[Sometimes copying and pasting from another source introduces unseen line breaks / characters into the paste. To make sure this is a clean copy / paste into the Endur ISQL window , first use this ‘remove line break‘ site to clean up the SQL ]
| SELECT bs.title as batch_sim_def , bsd.sequence , qv.query_name, sd.name as sim_def , rt.name as reval_type , bsd.extract_to_dw , bsd.sim_result_group_id FROM WHERE ORDER BY bs.title , bsd.sequence |
