Stack

Here you can execute a script with delay.

stackstack processstack statusstack resetstack 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

Description

Process to execute the stack

admin
stack process;

mentdb
1

stack status

Description

Get the status of the stack

admin
stack status;

mentdb
STACK STATUS
PROCESS_LIMIT=10
lock=false
lock_count=false

STACK SCRIPT
STACK PID

stack reset

Description

Reset lockers of the stack

admin
stack reset;

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 ..."
}

stack search <tableType> <script> <dtType> <dtMin> <dtMax> <dtOrder> <page> <nbByPage>

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"}