HELP WITH SHOUT DESTINATION TABLE OUTPUT

[rich_arredondo]

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.

[ThePirate]

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.