Hello Experts:
I want to implement a solution like this one:
http://www.scheduler-usage.com/modules. ... e.&start=0
In my production environment so I don't get any more .bat commands or DTS packages hung on Control-M.
I've been trying several ways to set it up, but none has worked, let me list my examples
When I use this method:
Shout Destination Table 'SYSTEM '
# Destination Type Adr Logical Name Physical Name
4 P S KILLJOB ctmkilljob -ORDERID $2
When using $2 to pass %%ORDERID parameter I get this message on U_KILLJXXX_XXX.log on PROCLOG folder under Control-M Server:
1128 14:50:05.42 GM_36_base_36_to_digit: Illegal input($) ascii is 36
1128 14:50:05.44 Trying to Rollback with empty transaction name
1128 14:50:05.44 DB_Rollback() - Failed in rollback() transaction
I have also used this one :
Shout Destination Table 'SYSTEM '
# Destination Type Adr Logical Name Physical Name
4 P S KILLJOB ctmkilljob -ORDERID $2
When using %2 to pass %%ORDERID parameter I get this message on U_KILLJXXX_XXX.log on PROCLOG folder under Control-M Server:
1128 14:55:08.04 GM_36_base_36_to_digit: Illegal input(%) ascii is 37
1128 14:55:08.04 Trying to Rollback with empty transaction name
1128 14:55:08.04 DB_Rollback() - Failed in rollback() transaction
Also this one:
Shout Destination Table 'SYSTEM '
# Destination Type Adr Logical Name Physical Name
4 P S KILLJOB ctmkilljob -ORDERID %%ORDERID
When using %%ORDERID to pass %%ORDERID parameter I get this message on U_KILLJXXX_XXX.log on PROCLOG folder under Control-M Server:
1128 14:58:16.12 GM_36_base_36_to_digit: Illegal input(%) ascii is 37
1128 14:58:16.13 GM_36_base_36_to_digit: Illegal input(%) ascii is 37
1128 14:58:16.13 Trying to Rollback with empty transaction name
1128 14:58:16.13 DB_Rollback() - Failed in rollback() transaction
I have also tried to implement a .bat script to be called by the Shout destination table with the following code:
cd C:\Program Files\BMC Software\CONTROL-M Server\Ctm_server\Exe
ctmkilljob -ORDERID %2
But when Trying to shout the destination table doesn't seem to be executing the script, as long as I don't see any LOG file on PROCLOG.
HELP WITH SHOUT DESTINATION TABLE OUTPUT
- rich_arredondo
- Nouveau
- Posts: 16
- Joined: 04 Nov 2011 12:00
My Control-M is on a windows box.
In my Shout Destination Table I have KILLJOB set up as
# Destination Type Adr Logical Name Physical Name
13 P S KILLJOB D:\Production\KillJob\KillJob.bat
and on the Control-M box I have a batch job (KillJob.bat) located at (D:\Production\KillJob\) at Physical Name above with the contents below
REM Kill a job that has been running too long.
cmd /C ctmkilljob -orderid %2
and on the PostProc tab of the job I want to kill in the event it hangs I have
When Param To Urgency Message
Exectime >n (xxx) KILLJOB Regular %%ORDERID
**above n is number of minutes and must be 001 for 1 minute**
Try this and see what you get because it works for me.
In my Shout Destination Table I have KILLJOB set up as
# Destination Type Adr Logical Name Physical Name
13 P S KILLJOB D:\Production\KillJob\KillJob.bat
and on the Control-M box I have a batch job (KillJob.bat) located at (D:\Production\KillJob\) at Physical Name above with the contents below
REM Kill a job that has been running too long.
cmd /C ctmkilljob -orderid %2
and on the PostProc tab of the job I want to kill in the event it hangs I have
When Param To Urgency Message
Exectime >n (xxx) KILLJOB Regular %%ORDERID
**above n is number of minutes and must be 001 for 1 minute**
Try this and see what you get because it works for me.