I am trying to issue 2 sql commands in the same job:

Truncate table table1

Insert into table1
Select *
From table2

The job fails when I put the 2 sql statements in the same job. It works fine if I separate them into 2 separate jobs. Is it just a syntax error? Thanks, Jeff

The correct syntax depends on your database version and must satisfy your database batch SQL syntax requirements, for example for Oracle this would be

BEGIN
EXECUTE IMMEDIATE 'Truncate table table1';
Insert into table1
Select *
From table2;
END;

: I am trying to issue 2 sql commands in the same job: Truncate table table1

: Insert into table1
: Select *
: From table2

: The job fails when I put the 2 sql statements in the same job. It works fine
: if I separate them into 2 separate jobs. Is it just a syntax error?
: Thanks, Jeff