On the schedule tab of the job, you can select 'Start Automatically when SQL Agent starts'.  This will run the job each time SQL Agent starts.

I don't believe that SQL Server can handle what you are asking for.  You would have to write that into your application.  I've worked in shops where un-authorized changes to...

It may help to get your question answered if you post the entire query.  Table DDL and sample data would also be helpful.

I think that your table DDL and sample data would be helpful here.

INSERT INTO OrderReceived

(OrderNumber,

 DateReceived)

 SELECT OrderNumber, min(DateReceived) FROM OrderDetail

 GROUP BY OrderNumber

If I'm understanding you correctly, you want to update the OrderReceived table with the earliest OrderNumber,DateReceived from the OrderDetail table. 

Try this:

INSERT INTO OrderReceived  (OrderNumber , DateReceived) SELECT TOP 1 OrderNumber, DateReceived FROM...

On top of what Jo is saying, not only will verifying your backups tell you if you have corrupt backup files, it will also help identify media problems. 

I can't speak much for SQL Server 2005, but if you do that in 2000, you're toast.  Your files are gone forever, with the exception of taking your harddrive into...

Can't you define a transaction through your application and call all 3 stored procedures from within that one transaction?  I don't have alot of experience from the application side of...

Also, make sure you are not in EM.

Whichever method you choose, you cannot be logged into the database that you are trying to set to single user mode.  I said use master, not necessarily because you have...

You have to make sure that there are not any users in the DB first.  If there are, you need to kick them out or run a script to do...

I would suggest verifying the permissions by performing a manual copy using you SQL user.  Log into your SQL box as the user in question, go to start>>run and type...

Has your MyCompany\SQLServer user been granted full control over the target folder?  Has the target folder been set up as a share? 

You 'da man Jeff.  That is an awesome post.  I have been attempting to get some of our developers to understand the importance of writting set based code over cursors...