Automating SQL Commands

[PhaZe]

Hello all,

I have a .sql file that has a lot of update commands that basically updates my database on a daily basis.


I was wondering if anyone knew how to automate this task. I tried using task scheduler in Vista but it only opens sql server management studio.

I usually open the .sql file in the management studio and have to connect using my log info, and then I click execute on the toolbar, and it runs my sql instructions.

Any ideas?

 

[KLin]

SQL Server can execute jobs, which includes executing sql statements.

http://msdn.microsoft.com/en-us/library/ms187910.aspx

 

[PhaZe]

I just found that article as well but when I'm in the Object explorer I see my databses, but I don't have "SQL Server Agent".

I wonder if I am missing something from the installation disk.

 

[KLin]

What version of sql server are you using? Sql express?

You're sol if it's SQL Express

http://www.microsoft.com/Sqlse...res.aspx#manageability

 

[PhaZe]

It's Sql server 2005 Developer.

I just put the disc in and tried to install it with all the options and it said I already have those features installed.

hmm

 

[KLin]

http://imar.spaanjaars.com/Ima...r/ManagementStudio.gif

Should be the last option. you may need to right click and start the service.

You then expand the SQL agent, and there's a subfolder for jobs.

 

[clamum]

Yup, make sure you have the SQL Agent installed (you don't even have to have the service running since you can start it within Management Studio) and create a scheduled job. Works like a charm.

 

[PhaZe]

I finally got it. Thanks KLin and clamum.