By using this script we can create Job for creating backup database.
The job will be automatically run in scheduled time.
In above script TESTDB is the db to be backedup.
'sa' is loginName.
E:\Backup\Database Backups\TESTDB is backup location.
@active_start_date=20101224,=>activity start date.
@active_end_date=99991231,=>activity end date
@active_start_time=200000,=>activity start time
@active_end_time=235959=>activity end time.