David,

Thanks for the response.  The server is set for Mixed Mode authentication, and I have jobs that have already been setup that are working fine.

Greg

Thanks John.  The problem is that SQL Server is not creating the job.

BTW: This is SQL Server 7.0 Std Ed.

Jeff,

Thanks! 

The query fails with INNER JOIN as well.  If I remove the ORDER BY clause it works.

The developer doesn't want to change anything.  This query has been working since...