Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sfinaki2000
Starting Member
2 Posts |
 Posted - 2005-03-30 : 20:09:59
|
| I would like to peform a scheduled job through MS SQL Server 2000 every hour but am unsure of how to do this. I'm fairly new to SQL, so please be patient with me. I have a number of functions that need to be run to populate certain tables, but am unsure of how to code this into the job scheduler. Anyone have any tips? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-30 : 21:15:40
|
| Books Online has plenty of information under "jobs". The easiest way to set them up is to use Enterprise Manager. Expand your SQL Server, then expand the Management folder, then go to Jobs. Create a new job (right-click with the mouse) and add the steps you need to perform your functions. T-SQL batches, procedure code, etc. can be executed as T-SQL steps. You can also execute operating system commands, ActiveX scripts, or replication functions. You can move steps around and control the flow of the job through or around each step.Once you save the steps you can set schedules and notifications too. Everything is clearly marked and it's all pretty easy to learn by doing. If you get stuck you can post follow-up questions to this thread and we'll answer them. |
 |
|
|
sfinaki2000
Starting Member
2 Posts |
Posted - 2005-03-31 : 12:28:04
|
| Thanks! That wasn't as hard as I thought! |
|
|
|
|
|
|
scheduled job for TSQL