automating a SQL Server "job"

[der_kluge]

I figure someone here will know this.

My background is in UNIX. In UNIX, I can do just about anything you want. But this new job I'm in is mostly NT server stuff - SQL Server, Informatica and NT Servers.

We have a set of SQL Server queries that we want to try to automate - as in "run these 15 queries once a month".

I know there is a task manager in Windows. If I can somehow wrap the queries into a "job" I can set it up in task manager.


Am I going about this the wrong way? Is there another way? What's the best way to do this?

I'm really out of my element here. Help!

 

[Rodrigo Istalindir]

You do it within SQL Server Enterprise manager. There's a 'Jobs' section in the tree. You can specify the schedule, enter the SQL commands you want it to execute, what to do when it fails, email notifications, etc.

 

[der_kluge]

You do it within SQL Server Enterprise manager. There's a 'Jobs' section in the tree. You can specify the schedule, enter the SQL commands you want it to execute, what to do when it fails, email notifications, etc.

Right I found that.

I was connected to two different databases, and I noticed that I was setting up a test job in the wrong database. "Oh, I need to set it up in the other one", so I went into the other database, and there's no such option in the object explorer. Now I'm really confused. Does something have to be set up at the database level in order for that option to be available??

FWIW, the one it was available on was SQLServer2K, and the one I want to set it up in is 2005.


Nevermind, I called our DBA, and she walked me through the process.

Apparently, the one in which it was available on is 2k, and the option shouldn't really be there, but there's not an easy way to remove it. The second is 2005, and it's not available because it's production, and I don't have permission.

 

[Rodrigo Istalindir]

Oh. They changed a lot of the management crap in 2005, and I don't know it well enough to tell you without having it in front of me. Every place I've worked that wanted to upgrade couldn't because their third-party apps won't support it.

I think I've got a VM around somewhere with it. If I can find it and fire it up, I'll take a look.

EDIT: Crossing posts. Ok, I'll not look it up then