AppWorx, Dollar Universe and Sysload Community

Expand all | Collapse all

Time Control Management - Execute script

  • 1.  Time Control Management - Execute script

    Posted Dec 22, 2016 11:03 AM
      |   view attached

     Hi guys,

    I searched for an answer for my problem, with no luck!!  Here it is...

    If a UPROC is taking more then 5 minutes, I need to kill it and start a new task.

    So I setup the UPROC with the following settings in the Time Control Management section:

    pprf1q6wycvm.jpghttps://us.v-cdn.net/5019921/uploads/editor/tt/pprf1q6wycvm.jpg" width="761">Hi guys,

     

     

     I also created the U_ALR_JOB.cmd file (that I have renamed .txt) under the "nodefiles" directory (ATTACHED).

    And here is the error message that I get in the log:

    20161222102215  Start Condition Check
                       Modified directly in the Engine by
                       operator : BRBatchJobSubmissionAccount
                        With no processing date
    20161222102215  Submitted in BATCH Q: SYS_BATCH
                      under ENTRY N°  : 052795
    VAR :
    SERVER             
    %BRSourceServerName%                                                                                                                                                                                                                                           
    VAR :
    JOBNAME            
    TestJobDU                                                                                                                                                                                                                                                      
    VAR :
    STEPNAME           
     
    20161222102216 max control duration: setting limit date/hour to 20161222102316
     
     
    20161222102216  BATCH starting
    uxsetabort allow=off queue=off
     
    control duration: error during custom script submission
     
    uxsetabort allow=on
     
    20161222102705  BATCH ending
     
    20161222102705  Start Completion Instructions
    20161222102705  *** NORMAL TASK COMPLETION ***
      *** NORMAL TASK COMPLETION ***
     
    Can somebody please help me with this?
    Thanks a lot :-)

     

    Attachment(s)

    txt
    U_ALR_JOB.txt   2 KB 1 version


  • 2.  Time Control Management - Execute script

    Posted Dec 22, 2016 11:12 AM

    Version 6.6.21
    Windows



  • 3.  Time Control Management - Execute script

    Posted Dec 29, 2016 09:25 AM
    Hi Mylene,

    Good day!

    Could you please explain what are you trying to achieve? Do you just want to kill the running uproc and restart the same uproc?

    Thanks
    Bob


  • 4.  Time Control Management - Execute script

    Posted Dec 29, 2016 09:42 AM
    Hi Mylene,

    If my guess is right, maybe you may want to use the command:
    uxend CTL

    Please check the Dollar Universe Command Manual for more details.


    Thanks
    Bob


  • 5.  Time Control Management - Execute script

    Posted Dec 30, 2016 11:25 AM

    Hi Bob,

    I would like to kill the process (uproc) and start another completely different task...



  • 6.  Time Control Management - Execute script

    Posted Dec 30, 2016 02:09 PM
    Hi Mylene_Chalut_6161

    Could you please try the following command to stop a job?
    uxend CTL

    Please check the Dollar Universe Command Manual for more details.


    Thanks
    Bob


  • 7.  Time Control Management - Execute script

    Posted Jan 05, 2017 11:21 AM

    That's the thing!!!  The job doesn't even stop if I set the action to "Kill UPROC" after the Absolute Duration time!!! 

    I am trying to use the Time Control Management - Execute script options. 

     

     



  • 8.  Time Control Management - Execute script

    Posted Jan 05, 2017 01:13 PM
    Hi Mylene_Chalut_6161

    Thank you for the information.

    I strongly suggest that you open a new incident and provide the following:

    -A new uxtrace result.

    -Th name of the uproc.

    -The U_ALR_JOB.


    Thanks
    Bob


  • 9.  Time Control Management - Execute script

    Posted Jan 05, 2017 01:50 PM
    OK Thanks :-)


  • 10.  Time Control Management - Execute script

    Posted Jan 05, 2017 01:57 PM

     Actually, I just found out that the uxalrjob/uxspvjob/uxsurjob commands are deprecated.  These commands are still delivered but doing nothing :s 

    https://community.automic.com/discussion/comment/18016#Comment_18016

    Great!!!
     



  • 11.  Time Control Management - Execute script

    Posted Jan 05, 2017 02:01 PM
    Mylene_Chalut_6161

    What about  the following? This is not using the uxalrjob

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    The job doesn't even stop if I set the action to "Kill UPROC" after the Absolute Duration time!!! 
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~




  • 12.  Time Control Management - Execute script

    Posted Jan 05, 2017 02:09 PM

    I realized that it's normal in my case.  Here is the scenario...

    The UPROC that I am trying to stop after a certain period of time is used to call a SQL Agent job.  So even if I kill the UPROC, it doesn't kill the job itself on the server.

    That is exactly why I am trying to execute a script if it takes to long for that first UPROC to execute.  We have created a stored procedures to kill the SQL Agent job.

    English is not my primary language.  I hope you understand what I am trying to explain.  I really need some help on that one :-(