MentDB, The digital brain.  About us Home
Back / All functions / Stack

Here you can execute a script with delay.

stackstack process statusstack process startstack process stopstack process_limitstack count_waitstack count_runningstack count_closedstack count_errorstack delete_wait_idstack delete_wait_scriptstack delete_closed_idstack delete_closed_scriptstack delete_error_idstack delete_error_scriptstack reset_error_nbattempt_idstack reset_error_nbattempt_scriptstack replay_error_idstack replay_error_scriptstack getstack search

stack <exeDate> <scriptName> <varName1> <varlue1> <varNameN> <varlueN>

Description

    To execute a script into the stack

Parameters

    exeDate:   The execution date - string - required
    scriptName:   The script name - string - required
    varName1:   The variable name 1 - string - not required
    varlue1:   The value 1 - string - not required
    varNameN:   The variable name N - string - not required
    varlueN:   The value N - string - not required
admin
stack (date now) "division.post" "[v1]" 10 "[v2]" 5
mentdb
2a

stack process status

Description

    Get the stack process status.

admin
stack process status
mentdb
Running ...

stack process start

Description

    Start the stack process.

admin
stack process start
mentdb
1

stack process stop

Description

    Start the stack process.

admin
stack process stop
mentdb
1

stack process_limit

Description

    Show the stack config process limit.

admin
stack process_limit
mentdb
4

stack count_wait

Description

    Count all waiting execution in the stack.

admin
stack count_wait
mentdb
2

stack count_running

Description

    Count all running execution in the stack.

admin
stack count_running
mentdb
4

stack count_closed

Description

    Count all closed execution in the stack.

admin
stack count_closed
mentdb
406

stack count_error

Description

    Count all error execution in the stack.

admin
stack count_error
mentdb
122

stack delete_wait_id <pid>

Description

    Delete a specific execution (wait).

Parameters

    pid:   The process id - number - required
admin
stack delete_wait_id 4
mentdb
1

stack delete_wait_script <scriptName>

Description

    Delete all executions for a specific script (wait).

Parameters

    scriptName:   The script name - string - required
admin
stack delete_wait_script "division.post"
mentdb
25

stack delete_closed_id <pid>

Description

    Delete a specific execution (closed).

Parameters

    pid:   The process id - number - required
admin
stack delete_closed_id 4
mentdb
1

stack delete_closed_script <scriptName>

Description

    Delete all executions for a specific script (closed).

Parameters

    scriptName:   The script name - string - required
admin
stack delete_closed_script "division.post"
mentdb
25

stack delete_error_id <pid>

Description

    Delete a specific execution (error).

Parameters

    pid:   The process id - number - required
admin
stack delete_error_id 4
mentdb
1

stack delete_error_script <scriptName>

Description

    Delete all executions for a specific script (error).

Parameters

    scriptName:   The script name - string - required
admin
stack delete_error_script "division.post"
mentdb
10

stack reset_error_nbattempt_id <pid>

Description

    Reset the number of attempt (error).

Parameters

    pid:   The process id - number - required
admin
stack reset_error_nbattempt_id 4
mentdb
1

stack reset_error_nbattempt_script <scriptName>

Description

    Reset the number of attempt (error).

Parameters

    scriptName:   The script name - string - required
admin
stack reset_error_nbattempt_script "division.post"
mentdb
1

stack replay_error_id <pid>

Description

    Replay a specific execution (error).

Parameters

    pid:   The process id - number - required
admin
stack replay_error_id 4
mentdb
1

stack replay_error_script <scriptName>

Description

    Replay all executions for a specific script (error).

Parameters

    scriptName:   The script name - string - required
admin
stack replay_error_script "division.post"
mentdb
7

stack get <pid>

Description

    To show a specific execution (with variables).

Parameters

    pid:   The process id - number - required
admin
stack get 4
mentdb
{ "lastattempt": "2018-01-04 10:39:17.0", "dtcreate": "2018-01-04 10:32:07.0", "nbattempt": "1", "dtclosed": null, "dtexe": "2018-01-04 10:32:07.0", "pid": "17", "login": "admin", "script": "addition.post", "dterror": "2018-01-04 10:39:17.0", "nbmaxattempt": "1", "lasterrormsg": "\nline 1 \u003e\u003e\u003e addition.post [v1] 12 [v2] 19 \nline 2 \u003e\u003e\u003e exception 1; \"\\\"your message ...\\\";\" ; 1: your message ..." }
Description

    To search an execution process

Parameters

    tableType:   The table type (wait|running|closed|error) - string - required
    script:   The script (can be null) - string - required
    dtType:   The date type (exe|closed|error|create|lastattempt) - string - required
    dtMin:   The min date - string - required
    dtMax:   The max date - string - required
    dtOrder:   The order (ASC|DESC) - string - required
    page:   The page - number - required
    nbByPage:   The number of line by page - number - required
admin
stack search "error" null "exe" (date datedifft (concat (date sysdate) " 00:00:00") "DAY" 10) (concat (date sysdate) " 23:59:59") ASC 1 5;
mentdb
{"column_types":["STRING","STRING","STRING","STRING","LONG","LONG","STRING","STRING","STRING","STRING","STRING"],"data":[],"columns":["pid","script","dtcreate","lastattempt","nbattempt","nbmaxattempt","dtexe","login","lasterrormsg","dtclosed","dterror"],"title":"stack "}




© 2012 - 2019 - Innov-AI.