19 lines
4.3 KiB
SQL
19 lines
4.3 KiB
SQL
REM INSERTING into ENVX_OPER.SYS_PARAM_TEMP
|
|
SET DEFINE OFF;
|
|
Insert into ENVX_OPER.SYS_PARAM_TEMP (PARAMETER_NAME,PARAMETER_VALUE,ID_STATUS_PARAMETER,CREATION_DATE,UNIQUE_PARAM_VALUE,PARAMATER_FUNC_NAME,PARAMETER_TYPE) values ('LOG_LEVEL','4','1',to_date('17/09/2021','DD/MM/RRRR'),'1','Nivel de almacenamiento de LOG',null);
|
|
Insert into ENVX_OPER.SYS_PARAM_TEMP (PARAMETER_NAME,PARAMETER_VALUE,ID_STATUS_PARAMETER,CREATION_DATE,UNIQUE_PARAM_VALUE,PARAMATER_FUNC_NAME,PARAMETER_TYPE) values ('JENKINS_QUEUE_TIMEOUT_SEC','20','1',null,'1',null,null);
|
|
Insert into ENVX_OPER.SYS_PARAM_TEMP (PARAMETER_NAME,PARAMETER_VALUE,ID_STATUS_PARAMETER,CREATION_DATE,UNIQUE_PARAM_VALUE,PARAMATER_FUNC_NAME,PARAMETER_TYPE) values ('JENKINS_PRIMARY_AUTH_BASIC','c2ljZDoxMTY5NjE5NGRmYTRhNTJjZjMyMzhhNjU0ZjdkYTMxODI2','1',to_date('17/09/2021','DD/MM/RRRR'),'1','HTTP Authorization Basic Jenkins Primario',null);
|
|
Insert into ENVX_OPER.SYS_PARAM_TEMP (PARAMETER_NAME,PARAMETER_VALUE,ID_STATUS_PARAMETER,CREATION_DATE,UNIQUE_PARAM_VALUE,PARAMATER_FUNC_NAME,PARAMETER_TYPE) values ('MAILER_URL','http://osbdes.caja.com/osb/commons/mailer','1',to_date('17/09/2021','DD/MM/RRRR'),'1','URL del servicio mailer',null);
|
|
Insert into ENVX_OPER.SYS_PARAM_TEMP (PARAMETER_NAME,PARAMETER_VALUE,ID_STATUS_PARAMETER,CREATION_DATE,UNIQUE_PARAM_VALUE,PARAMATER_FUNC_NAME,PARAMETER_TYPE) values ('JENKINS_SECONDARY_AUTH_BASIC','c2ljZDoxMTY5NjE5NGRmYTRhNTJjZjMyMzhhNjU0ZjdkYTMxODI2','1',to_date('17/09/2021','DD/MM/RRRR'),'1','HTTP Authorization Basic Jenkins Secundario',null);
|
|
Insert into ENVX_OPER.SYS_PARAM_TEMP (PARAMETER_NAME,PARAMETER_VALUE,ID_STATUS_PARAMETER,CREATION_DATE,UNIQUE_PARAM_VALUE,PARAMATER_FUNC_NAME,PARAMETER_TYPE) values ('JENKINS_PRIMARY_URL','http://sicddes.lacaja.com.ar:8080/jenkinsPrimario','1',to_date('17/09/2021','DD/MM/RRRR'),'1','URL base Jenkins Primario',null);
|
|
Insert into ENVX_OPER.SYS_PARAM_TEMP (PARAMETER_NAME,PARAMETER_VALUE,ID_STATUS_PARAMETER,CREATION_DATE,UNIQUE_PARAM_VALUE,PARAMATER_FUNC_NAME,PARAMETER_TYPE) values ('JENKINS_SECONDARY_URL','http://sicddes.lacaja.com.ar:8080/jenkinsPrimario','1',to_date('17/09/2021','DD/MM/RRRR'),'1','URL base Jenkins Secundario',null);
|
|
Insert into ENVX_OPER.SYS_PARAM_TEMP (PARAMETER_NAME,PARAMETER_VALUE,ID_STATUS_PARAMETER,CREATION_DATE,UNIQUE_PARAM_VALUE,PARAMATER_FUNC_NAME,PARAMETER_TYPE) values ('JIRA_USERNAME','admin','1',null,'1',null,null);
|
|
Insert into ENVX_OPER.SYS_PARAM_TEMP (PARAMETER_NAME,PARAMETER_VALUE,ID_STATUS_PARAMETER,CREATION_DATE,UNIQUE_PARAM_VALUE,PARAMATER_FUNC_NAME,PARAMETER_TYPE) values ('JIRA_PASSWORD','adminsistemas20caracteres','1',null,'1',null,null);
|
|
Insert into ENVX_OPER.SYS_PARAM_TEMP (PARAMETER_NAME,PARAMETER_VALUE,ID_STATUS_PARAMETER,CREATION_DATE,UNIQUE_PARAM_VALUE,PARAMATER_FUNC_NAME,PARAMETER_TYPE) values ('JIRA_PROJECT_TYPE','ITDES','1',null,'0','Desarrollo (ITDES)',null);
|
|
Insert into ENVX_OPER.SYS_PARAM_TEMP (PARAMETER_NAME,PARAMETER_VALUE,ID_STATUS_PARAMETER,CREATION_DATE,UNIQUE_PARAM_VALUE,PARAMATER_FUNC_NAME,PARAMETER_TYPE) values ('JIRA_PROJECT_TYPE','ITGCI','1',null,'0','Gestion Interna (ITGCI)',null);
|
|
Insert into ENVX_OPER.SYS_PARAM_TEMP (PARAMETER_NAME,PARAMETER_VALUE,ID_STATUS_PARAMETER,CREATION_DATE,UNIQUE_PARAM_VALUE,PARAMATER_FUNC_NAME,PARAMETER_TYPE) values ('JIRA_PROJECT_TYPE','MDA','1',null,'0','Mesa de Ayuda (MDA)',null);
|
|
Insert into ENVX_OPER.SYS_PARAM_TEMP (PARAMETER_NAME,PARAMETER_VALUE,ID_STATUS_PARAMETER,CREATION_DATE,UNIQUE_PARAM_VALUE,PARAMATER_FUNC_NAME,PARAMETER_TYPE) values ('JIRA_TICKET_URL','http://jira.caja.com:20000/browse/','1',null,'1','URL de Jira para consultar los ticket',null);
|
|
Insert into ENVX_OPER.SYS_PARAM_TEMP (PARAMETER_NAME,PARAMETER_VALUE,ID_STATUS_PARAMETER,CREATION_DATE,UNIQUE_PARAM_VALUE,PARAMATER_FUNC_NAME,PARAMETER_TYPE) values ('JENKINS_LOG_JOB','/job/','1',null,'1','Parametro para ingresar al build de jenkins',null);
|
|
Insert into ENVX_OPER.SYS_PARAM_TEMP (PARAMETER_NAME,PARAMETER_VALUE,ID_STATUS_PARAMETER,CREATION_DATE,UNIQUE_PARAM_VALUE,PARAMATER_FUNC_NAME,PARAMETER_TYPE) values ('JENKINS_LOG_CONSOLE','/console','1',null,'1','Parametro para el LOG del build de Jenkins',null);
|
|
Insert into ENVX_OPER.SYS_PARAM_TEMP (PARAMETER_NAME,PARAMETER_VALUE,ID_STATUS_PARAMETER,CREATION_DATE,UNIQUE_PARAM_VALUE,PARAMATER_FUNC_NAME,PARAMETER_TYPE) values ('SICD_URL','http://sicddes.lacaja.com.ar:8011/ords/sicd/r/sicd','1',null,'1','URL de acceso al sistema',null);
|