We've had a couple of questions about "fire and forget" processing and exporting data to alternative formats. One of the easiest way to accomplish these tasks is using JOBS. They can easily be set up and executed from within Enterprise Manager and just as easily controlled from Transact-SQL.
quote: missing sp_start_job and all other sp's related to SQL Server Agent ? <P>Hello, In SQL 7 and SQL 2000 Beta we have, we don't see any of those SQL Server Agent stored procedures. What's wrong ? We have Enterprise versions of SQL.