$(function () { pageContext.i18n.modTalk = 'moderation talk'; pageContext.i18n.replyToComment = 'Reply'; pageContext.i18n.modTalkEmpty = 'moderation talk is empty'; pageContext.url.getModTalk = "/comments/%25ID%25/listModTalk.json"; pageContext.url.possibleCommentRecipients = "/comments/%ID%/possibleRecipients.json"; pageContext.url.commentEdit = '/comments/%25ID%25/edit.html'; pageContext.url.commentView = '/comments/%ID%/view.html'; pageContext.i18n.commentVisibility = { 'full': 'Viewable by all users', 'op': 'Viewable by the original poster', 'mod': 'Viewable by moderators', 'opAndMod': 'Viewable by moderators and the original poster', 'other': 'Advanced visibility', 'dialogTitle': 'Comment visibility', 'selectGroups': 'Visible to groups', 'selectOther': 'Other recipients', 'selectOriginalPoster': 'Original poster', 'selectModerators': 'Moderators', 'selectAssignees': 'Asked to answer users' }; pageContext.i18n.commentMenuLabels = { 'comment-edit': 'comments.menu.edit', 'comment-delete': 'comments.menu.delete', 'comment-convert': 'comments.menu.convert' };pageContext.i18n.answer= { bestAnswer: 'Best Answer', controlBar : { accept: 'Accept', unaccept: 'Unaccept', acceptCommand: 'Accept this answer as correct', cancelAcceptedCommand: 'Remove this answers accepted status' } }; window.croles = { u: false, op: false, m: false, og: false, as: false, ag: false, dc: false, doc: false, eo: false, ea: false }; tools.init({ q: { e: false, ew: false, eo: false, r: false, ro: false, d: false, dow: false, fv: false, c: false, co: false, p: false, tm: false , ms: false, mos: false }, n: { f: false, vf: false, vfo: false, vr: true, vro: true, c: false, co: false, vu: false, vd: false, w: false, wo: false, l: false }, c: { e: false, eo: false, d: false, dow: false, ta: false, tao: false, l: false }, a: { e: false, ew: false, eo: false, d: false, dow: false, a: false, aoq: false, ao: false, tc: false, tco: false, p: false, tm: false }, pc: croles }, { tc: true, nsc: true }); commandUtils.initializeLabels(); }); Skip to Content
avatar image
Former Member

Job Scheduling for Expected Event Monitoring

Hi,

I am trying to schedule a job for expected event monitoring "/SAPTRX/EE_MONITOR", but when i schedule the job hourly then the job is getting overlapped with the privious one which is producing dump - DBSQL_DUPLICATE_KEY_ERROR.If we have to run this job hourly only then how can we schedule the job is such a way that each time when job runs it will check  for the completion of privious job.please suggest.

Thanks

Vaibhav

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 25, 2015 at 06:09 AM

    Hi Vaibhav,

    We had a similar requirement in the previous project but we have done below option as we can't predict how long the job runs.

    In my opinion, you can achieve like below.

    Step -1:

    1. Go to SE38 and create a variant for program RSBTONEJOB2.

    2. Add Step 2 Job name, Report /SAPTRX/EE_MONITOR and Variant.


    Step - 2.


    1.Add Step 1 of program, Report RSBSTONEJOB2 and new Variant.

    2. Add program RSBTONEJOB2 and newly added variant

    3. Add step 2 and include program /SAPTRX/EE_MONITOR.


    Outcome:


    Step 1 RSBSTONEJOB2 checks the previous job program /SAPTRX/EE_MONITOR runs and it would cancel the current one without making any dump.


    If you have CPS scheduling tool, you can achieve this function, i believe.


    Or else, just simply calculate the maximum amount of time it runs in a day.


    For example -


    9 AM to 12 PM - it runs close 2 hours but runs after 2 PM only one hour.


    In that case, you can schedule multiple job name or same name with same program to schedule in different custom time daily.


    Regards


    GGOPII



    Add comment
    10|10000 characters needed characters exceeded

  • Aug 25, 2015 at 06:20 AM

    Hi Vaibhav,

    normally EE_MONITOR should not run over one hour.

    How many overdue EE are found by the job? You should maybe run a trace to see what costs so much runtime.

    Best regards,

    Steffen

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Vaibhav,

      Two possibilities:

      1. Check Custom Activity functions which are assigned in Expected Event Monitor and Optimize and remediate those function codes.

      2. You have to check these many events overdue every hour or the batch job setting overdue every time which are previously already overdue set.  You have to look out expected event activity which makes this running longer.

      Regards


      GGOPII

  • avatar image
    Former Member
    Aug 26, 2015 at 03:12 AM

    Hi Gopi,

    Thanks for your suggestion.

    I checked with custom functon of Expected Event Monitor, it seems no issue from that prospective,checking with the second option.

    Hi Steffen,

    Thanks for the refrence document, i hope it will help to reduce the no. of  expected events.

    Add comment
    10|10000 characters needed characters exceeded