How to Schedule a Backup? (not a maintenance plan)

[jmsabatini]

I am trying to schedule a backup by going to Management/Backup/Backup a Database and assigning a schedule. The problem is, every time I try to assign a backup to a schedule and hit Ok, I don't see anything scheduled...anywhere. I'm worried that these tasks I'm scheduling are hidden somewhere in the system now and are going to cause problems. Any ideas? The reason I don't want to use a maintenance plan is because I need to overwrite the same backup file (so I created a backup device that references the file I want to keep using).

Please advise. Thanks!

 

[SQLBill]

Schedule JOBS are in the Jobs area.

Use Enterprise Manger, drill down to Management, expand SQL Server Agent, click on Jobs.

That's where you should find any Jobs you've created.

-SQLBill

 

[jmsabatini]

Thanks SQLBill!!!

 

[wyldsider]

Is there a way to schedule these from direct SQL queries, for those of us programming against MSDE?

Jack De Winter
Software Developer
MedTel Software

http://www.medtel.on.ca

 

[SQLBill]

Jack,

I don't use MSDE, but I'm guessing that since you use OSQL (command prompt) commands you could create the command and script it to run via Windows commands.

-SQLBill

 

[vidru]

Jack,

Set up a sample job (backup, etc.) on a machine that you can access with Enterprise Manager. After you've got the job set up, in Enterprise Manager, browse to the Server>Management>SQL Server Agent>Jobs. Right click on the job, go to 'All Tasks' and choose 'Generate SQL Script'.

If you look at the script, you'll see the script for creating the job, the steps, and the schedule. Using osql, you would pass in the script to set the job up on a machine running MSDE.

-Dave