We had a scenario where a huge table like BSEG in Sap system needs to be loaded to target DB. For speeding up the load the refresh was splitted into multiple segments using RefreshRestrict resulting in multiple refresh jobs. Due to environmental constraints we cannot run more more than 3 refresh in parallel. We have more than 50 refresh jobs in suspended mode based on conditions. Since we know based on performance each job will take atmost 1 hour to complete. We want to schedule the job at the interval of an hour to trigger automatically. I tried to use the trig_crono attribute of the job but it's not working for suspended job. The same is working when the job is in pending mode.
Can you please help?
You should use the job attribute trig_crono to set the schedule, and then Unsuspend the job.
The job will then be put in a Pending state, waiting for the scheduler the trigger the job.