How to schedule a suspended refresh job?

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #10651
    register
    Participant

    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?

    • This topic was modified 2 years, 7 months ago by Mark. Reason: Removing visible HTML code
    • This topic was modified 2 years, 7 months ago by Mark.
    #10661
    Mark
    Keymaster

    Hi There,

    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.

    Mark.

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.

© 2020 HVR

Test drive Contact us