Scheduling loads using BODS with cntl-M

[former_member205400]

I'm looking to schedule some of our jobs using control-m.

Is there a direct connection method we should be using in lieu of a trigger file being placed on our server?

Mike

[Former Member · Accepted solution]

Hello

It is possible to "export execution command" from the web administrator.  This creates a batch file (or shell script) that can be invoked by an external scheduler.

Jobs can also be invoked via the web service.

The Administrator guide covers both topics.

Michael

[former_member205400 · Accepted solution]

Michael, I didn't see that in my admin manual. Do you know what page? Mike

[Former Member · Accepted solution]

It actually depends which version you are using, but for 14.1, its in the administrator section of the management console guide.

Michael

[former_member205400 · Accepted solution]

Michael,

I went to the mgt console and exported it like you were saying.

It created a file like "myrepo.txt". I renamed it to "myrepo.sh" and then made it executable.

I tried to exe it like ./myreppo.sh and I get:

./myreppo.sh line 1: F218F8CD8C48FC6F499E59E2B0042369+04000000001A030100100000461444FC45630604A4BF4C51F51395177341593DE56FC84C9BE63BFB582CC6E795DD496B2BDC1F7EE6AA9CF943F1A89437DDE83082D1D988092D39A0EE48015DF123743078128D4FB91C7D61076B2B9ADCC13AAE4C8EDFDD6E7BB1016351EC8B41F441127246611A68B6DC6B709BC461337A7AFC1A7011CCA0A20AD624BCF3A7B84764543B77A67E8D77F22A99FB52BD5DD03570BBC774D97C483DE9B892AB750484E69577278BE01D8E444934DCF91DC0A73D0AABF45F972BED6BAE885FEB2AFF3C9CF5C73EB7F0C1F8D619535FA144C7AC48F588B9030503F689CEA26F7E9BD0B3EED9760DF0AAA5A098C3BFC40464D1454A0FDC1FBD17DAB4CA4B395A55E9AC586B73D0FBBCB0454BE0C2352DDEF2C3D0BCEB7ABCBBFB9972961FD0C47850A0E2E150B29D7F496F3FCC4F7E2150B570C64485B524F144628DB93EA67DEFDEDCB5C6727BF049E2E45448: command not found

Am I on the right track?

Mike

[dv8shn · Accepted solution]

Michael, when you Export an execution command, two files are created. The executable file and a parameters file which is read when the executable runs. You modified the parameters file.

Have a closer look at the file names are similar and from memory are in the same directory on the Job Server.

Bob

[former_member205400 · Accepted solution]

Yep ur right. It put a .sh file in the /app/bods/sapbo/dataservices/log directory and I could exe it.