How to run shell scripts in sequence jobs

[developeretl]

Hi,
Iam having sequence jobs i need to run shell scripts .... how should i use them in the sequence jobs and what conditions ineed to keep to make sure it runs successfully.......

[Sreenivasulu]

Pls do not use SMS style dotted statementes. Use the ExecSH feature in the job properties. You can use it a before-job or afer-job routine. You can also return an error code

Regards
Sreeni

[developeretl]

Iam using sequence job so i cant use after job or before job.

[ray.wurlod]

how should i use them in the sequence jobs

Invoke from Execute Command activity.

what conditions ineed to keep to make sure it runs successfully.......

That's entirely within the purview of the author of the shell script. The job sequence will detect the exit status of the shell script (accessible as an activity variable and in a trigger on the Execute Command activity). Usual rules: 0 = success, non-zero = failure.

[developeretl]

Hi Ray,
Thanks for the reply. Iam seeing trigger tab what should I mention in that tab.

[kris007]

The trigger conditions allow you to design/define what you want after the execution of the shell script (Execute Command Activity) or other prior Job Activities in the Job Sequence. You can go through the help to understand what each of the options within the drop down box of the trigger tab means.

[kris007]

Pls do not use SMS style dotted statementes.

And you just used one