Difference between revisions of "SQWareProduction:mssql:bin:sqwmsq RunJob.ksh"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
| Line 5: | Line 5: | ||
| | | | ||
<pre> | <pre> | ||
| − | |||
| − | |||
</pre> | </pre> | ||
| | | | ||
<pre> | <pre> | ||
Not sending mail because you are in connected mode !!! | Not sending mail because you are in connected mode !!! | ||
| − | + | Error, ExecEnvType='LinuxKO' ... | |
</pre> | </pre> | ||
| | | | ||
{{SQWareProduction_sqwmsq_RunJob.ksh_example}} | {{SQWareProduction_sqwmsq_RunJob.ksh_example}} | ||
}} | }} | ||
Latest revision as of 08:35, 24 December 2024
Contents
Presentation
Script $gvsqw_MsqBin/sqwmsq_RunJob.ksh :
Online help
The online help is available for most scripts with the -h option.
Ex: $gvsqw_MsqBin/sqwmsq_RunJob.ksh -h
Content of this assistance :
Can't find if env is 'SqlCmd' or 'FreeTds' ! Sourcing sqwmsq_Global.lib v2024.08 SQWareProduction for MsSql (dbSQWare) ... Run sqwmsq_RunJob.ksh -h : 2024-12-24 08:36:38 __________________________________________________________________ Program informations SqwVersion=2024.08 / 2024.08 2024-12-24 08:36:38 Copyright 2010-2024, dbSQWare (www.dbsqware.com) Linux dbsqware02 4.15.18-21-pve #1 SMP PVE 4.15.18-48 (Fri, 20 Sep 2019 11:28:30 +0200) x86_64 GNU/Linux gvsqw_GenPath=/home/dbsqware/dbSQWare/SQWareProduction/mssql/bin Path=/home/dbsqware/dbSQWare/SQWareProduction/mssql/bin ./sqwmsq_RunJob.ksh -h dbsqware@dbsqware02 sqwmsq_RunJob.k,dbsqware ./sqwmsq_RunJob.ksh -h `-pstree -aul 23244 __________________________________________________________________ Not sending mail because you are in connected mode !!! Error, ExecEnvType='LinuxKO' ... Begining : 2024-12-24 08:36:38 End : 2024-12-24 08:36:38 Duration : 00:00:00
Error management
Errors passing arguments
This type of message is generated:
If you are connecting through a terminal, no mail will be sent and you will have more this kind of message:
Not sending mail because you are in connected mode !!! Error, ExecEnvType='LinuxKO' ...
If you are not connected to a terminal, the error message appears and is sent by mail to the address contained in the variable $gvsqw_GlobalMail (See help customize this variable). The subject line will always start by "$gvsqw_MailMsg_mssql : " (See help customize this variable).
Execution errors
Whether you are or not connected to a terminal, the error message appears and an email containing a summary of treatment errors is sent to the address contained in the variable $gvsqw_Mail_mssql (See help customize this variable). The subject line will always start by "$gvsqw_MailMsg_mssql : " (See help customize this variable).
Usage examples
Can't find if env is 'SqlCmd' or 'FreeTds' ! Sourcing sqwmsq_Global.lib v2024.08 SQWareProduction for MsSql (dbSQWare) ... Run sqwmsq_RunJob.ksh -s : 2024-12-24 08:35:41 __________________________________________________________________ Program informations SqwVersion=2024.08 / 2024.08 2024-12-24 08:35:41 Copyright 2010-2024, dbSQWare (www.dbsqware.com) Linux dbsqware02 4.15.18-21-pve #1 SMP PVE 4.15.18-48 (Fri, 20 Sep 2019 11:28:30 +0200) x86_64 GNU/Linux gvsqw_GenPath=/home/dbsqware/dbSQWare/SQWareProduction/mssql/bin Path=/home/dbsqware/dbSQWare/SQWareProduction/mssql/bin ./sqwmsq_RunJob.ksh -s dbsqware@dbsqware02 sqwmsq_RunJob.k,dbsqware ./sqwmsq_RunJob.ksh -s `-pstree -aul 8060 __________________________________________________________________ Not sending mail because you are in connected mode !!! Error, ExecEnvType='LinuxKO' ... Begining : 2024-12-24 08:35:41 End : 2024-12-24 08:35:41 Duration : 00:00:00
