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 |
|
sanjay5219
Posting Yak Master
240 Posts |
 Posted - 2011-07-13 : 04:18:08
|
| Hi All,I just wated a suggestion. I have around 25 procedure which i want to run in every one hour.Means in every one hour all these 25 procedure will run. I wanted to check it is good to put all these storeed procedure in on JOB or 25 diffrent jobPlease suggest |
|
|
vaari
Starting Member
15 Posts |
Posted - 2011-07-13 : 05:06:07
|
| The decision would depend on the following:a) Do you want these procedures to run one after the other or in parallel (and can they be run in parallel)b) If there's an error in one procedure do you want the others to continue executing or do you want to stop execution on errorc) what do these 25 procedures do? i.e. can you combine what they do into one procedure and execute only that one procedure every hour?If I had to make a decision on the information you provided - I'd create one job with 25 steps and each step executing one of these procedures (that way I can set order of execution and also jump to the step I want to in case of error etc). |
 |
|
|
|
|
|
SQL Procedure Suggestions