SQL & PL/SQL

Hi,

I am a beginner to Control M jobs in Unix. I couldnt find it on google as to how to create a simple control m job. So i am posting it here.

Can someone tell how to create a Control M job that does the simple update as given below at 12 AM every night.

begin

Update table

set col1 = 'S';

end;

Thanks

Gautam