I was able to run the SQL you posted without problem on SQL Server 2005 Standard 9.0.3159 32 bit.

I did get that error while editing the job step and clicking the parse button. When I ran the job with just the code you posted, it ran successfully.