Please give me a query to create a job on Sql server 2005 for taking a back up. I want to run the job when I would like.

Thanks for the reply. I tried the query that you suggested. It worked fine when I executed it on the server machine. I tried to fire the same query from...