Template:SQWareProduction sqwmsq RunJob.ksh example: Difference between revisions
Jump to navigation
Jump to search
m Updated by BatchUser |
No edit summary |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<pre> | <pre> | ||
Can't find if env is 'SqlCmd' or 'FreeTds' ! | Can't find if env is 'SqlCmd' or 'FreeTds' ! | ||
Sourcing sqwmsq_Global.lib | Sourcing sqwmsq_Global.lib v2025.06 SQWareProduction for MsSql (dbSQWare) ... | ||
#Standard generic help for script sqwmsq_RunJob.ksh: | |||
$gvsqw_Msq/sqwgen_RunJob.ksh -h | |||
#Display online help for this script | |||
$gvsqw_Msq/sqwgen_RunJob.ksh -Locale en -h | |||
#Display online help for this script with forcing of the 'en' locale (by default locale managed by $gvsqw_Locale) | |||
$gvsqw_Msq/sqwgen_RunJob.ksh -s | |||
#Display usage examples for this script | |||
$gvsqw_Msq/sqwgen_RunJob.ksh -I <Instance> -A <action> | |||
#Search action <action> in $gvsqw_RootCfg/sqwmsq_Jobs.cfg | |||
#and execute command line with eval function | |||
#genarate log file "$gvsqw_LogDir/"$(basename $lvsqw_Script|sed 's,.ksh$,,')_$(date +'%Y%m%d_%H%M%S').log | |||
#genarate error file "$gvsqw_LogDir/"$(basename $lvsqw_Script|sed 's,.ksh$,,')_$(date +'%Y%m%d_%H%M%S').err | |||
$gvsqw_SQWareCentralPath/bin/sqwgen_RunJob.ksh -I <Instance> -A <action> -AddMail 'mymail1@mydomaine.com,mymail2@mydomaine.com' | |||
#Adds the email list to the default address managed by $gvsqw_GlobalMail | |||
$gvsqw_SQWareCentralPath/bin/sqwgen_RunJob.ksh -I <Instance> -A <action> -SendReport | |||
#Sends the log by email at the end of the process, even if there is no error (by default, only in case of an error) | |||
$gvsqw_SQWareCentralPath/bin/sqwgen_RunJob.ksh -I <Instance> -A <action> -SendMailOnError | |||
#Run the script sqwgen_RunJob.ksh and will send mail on error. | |||
#By default, it uses the gvsqw_SendMailOnError variable (SendMailOnError='$gvsqw_SendMailOnError'). | |||
#You can change the default for the entire environment by setting this variable | |||
#in the configuration file $gvsqw_PgBin/../etc_cust/sqwpg_GlobalVar.cfg | |||
</pre> | </pre> | ||
Latest revision as of 18:51, 1 July 2025
Can't find if env is 'SqlCmd' or 'FreeTds' ! Sourcing sqwmsq_Global.lib v2025.06 SQWareProduction for MsSql (dbSQWare) ... #Standard generic help for script sqwmsq_RunJob.ksh: $gvsqw_Msq/sqwgen_RunJob.ksh -h #Display online help for this script $gvsqw_Msq/sqwgen_RunJob.ksh -Locale en -h #Display online help for this script with forcing of the 'en' locale (by default locale managed by $gvsqw_Locale) $gvsqw_Msq/sqwgen_RunJob.ksh -s #Display usage examples for this script $gvsqw_Msq/sqwgen_RunJob.ksh -I <Instance> -A <action> #Search action <action> in $gvsqw_RootCfg/sqwmsq_Jobs.cfg #and execute command line with eval function #genarate log file "$gvsqw_LogDir/"$(basename $lvsqw_Script|sed 's,.ksh$,,')_$(date +'%Y%m%d_%H%M%S').log #genarate error file "$gvsqw_LogDir/"$(basename $lvsqw_Script|sed 's,.ksh$,,')_$(date +'%Y%m%d_%H%M%S').err $gvsqw_SQWareCentralPath/bin/sqwgen_RunJob.ksh -I <Instance> -A <action> -AddMail 'mymail1@mydomaine.com,mymail2@mydomaine.com' #Adds the email list to the default address managed by $gvsqw_GlobalMail $gvsqw_SQWareCentralPath/bin/sqwgen_RunJob.ksh -I <Instance> -A <action> -SendReport #Sends the log by email at the end of the process, even if there is no error (by default, only in case of an error) $gvsqw_SQWareCentralPath/bin/sqwgen_RunJob.ksh -I <Instance> -A <action> -SendMailOnError #Run the script sqwgen_RunJob.ksh and will send mail on error. #By default, it uses the gvsqw_SendMailOnError variable (SendMailOnError='$gvsqw_SendMailOnError'). #You can change the default for the entire environment by setting this variable #in the configuration file $gvsqw_PgBin/../etc_cust/sqwpg_GlobalVar.cfg