Backup Database

[scabral79]

Is there a way to use the Backup Database command to backup a database to disk from a stored proc?

for example, if you try to run the following command from a stored proc:

Backup database ABLTEST to disk='e:\mssql\mssql\backup\Daily\ABLTest.bak'

I get the following error:

Incorrect syntax near 'Backup'.

Basically, what i need to do is figure out a way to backup the database either by using stored proc or dts package, but NOT using the sql scheduler.

thanks
scott