DSXchange

My server time shows: Mon Oct 22 14:43:48 Asia/Riyadh 2012 Client also shows the same time. Trying to schedule the job at 14.50, receiving the below error. even the thirdpary scheduler also facing time mismatch. can anyone help me to resolve the issue Error: -------- Error adding to schedule: at: 04...

Query looks fine, you may need to improve performance at table level. as craig said go for table index with the columns used in the filter condition (even you can go for index force in the query). with the given count of table A that too with a 'LIKE' filter, definitely the query will take more time...

i hope no function exist in the name IsNotNull(), use Not(IsNull(inputlink.Buss_unit))

oracle procedures very well can be called from before/after sql of oracle stage. check for the connection strings and qualify the procedure with the right schema..