How to schedule a suspended refresh job?
- This topic has 1 reply, 2 voices, and was last updated 2 years, 7 months ago by .
- You must be logged in to reply to this topic.
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.
Hope this helps.
© 2020 HVR
It appears you are still using Internet Explorer. Support for IE has been discontinued by Microsoft, and many features of our site may not display or work properly.