apply to target server failed for job sql 2005

I'm trying to create a job by simple sql squery code, that is to delete a table and insert new filtered data from another table.

My script is

delete from table1

insert into table1

select * from table2

*Both tables have the same number of columns. That query was put into the Job step list.