Unable to execute Stored Procedure from CRON

Hi,

I am very new to this environment - I hope this is the right platform to discuss my issue:

I created a CRON job to run a Stored Procedure from our database - Sybase.

Within the Stored Procedure there is a TRUNCATE table and CREATE table function.

the CRON job fails to run with Msg 226 saying TRUNCATE not allowed within a multi-statement transaction - as well as the CREATE table...

Is there some limitation I am not aware of or is there a simple way to get around this?

thanks, Don

Out of curiosity.. did you run the stored procedure successfully in stand alone mode first rather running through cron..? Because the error seems to be related to database and not with unix environment.

yes - the Stored Procedures run sucessfully stand alone - they will not run via CRON.

Maybe there are some permissions on the database side that need to be set?