I am planning to trace which scheduled job is taking more time.
I have verified BEGIN_TS and END_TS columns in S_NQ_INSTANCE table. The column BEGIN_TS is showing 01:30:09 AM
but actual scheduled time is 07:00:09 AM.The difference is around 5.58 hours.
My PC timezone is UTC+5:30 and OBI Server timezone is UTC+5:30 but in S_NQ_JOB table showing TS_ZONE column as GMT+5:30.
I have veriefied in JOB Manager also it is showing as per schuled time(07:00:09 AM).
If I run query in OBI end it is showing around -5:30 hous differnce.
In Job Manager
In report level
Please help me, how to get exact schedule time in report.
You can configured the timezones in obiee by below doc.
Generally the timezone you are looking in the front in the application is by presentation services from instanceconfig.xml file and in the database it is from bI Server.