Starting of Data Stage Job
Posted: Thu May 15, 2008 6:19 am
Hi All
We are scheduling a Data Stage Job to be started every day at 7PM which is getting me the incremental load from a database.
My select query is as follows
select * from XX where datetime >= (sysdate-1)
Records are being pumped in to this table every second.
Is there a chance i will miss out some records because the data stage server takes a few seconds based on the server utilization for starting my job or will the job start for sure every day at 7PM and i will not miss any records
Thanks
Pavan
We are scheduling a Data Stage Job to be started every day at 7PM which is getting me the incremental load from a database.
My select query is as follows
select * from XX where datetime >= (sysdate-1)
Records are being pumped in to this table every second.
Is there a chance i will miss out some records because the data stage server takes a few seconds based on the server utilization for starting my job or will the job start for sure every day at 7PM and i will not miss any records
Thanks
Pavan