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 |
|
shanmp
Starting Member
13 Posts |
 Posted - 2009-01-06 : 01:15:42
|
| Hi All, I need to run only a particular step in Job. i.e., if there are four steps.. I need to run only the fourth step in job. I am using TOAD for SQL server. Please let me know how to run the step inidividually in job. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2009-01-06 : 05:09:06
|
| I don't think this is possible...alternative solutions would be to create stored procedures out of each job step and execute those on demand.- Lumbago |
 |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-01-06 : 05:24:29
|
| I haven't ever used it but I think you can define the step number if you are running the job using sp_start_job. |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2009-01-06 : 05:40:31
|
quote:
I haven't ever used it but I think you can define the step number if you are running the job using sp_start_job.
This is true but it will also run all the steps that follow the starting step so it doesn't really comply with the requirements...- Lumbago |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-01-06 : 05:46:25
|
| Agree,I mentioned it cos he said "if there are four steps.. I need to run only the fourth step in job" |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-06 : 10:30:20
|
quote:
Originally posted by sakets_2000
Agree,I mentioned it cos he said "if there are four steps.. I need to run only the fourth step in job"
Why not put Fourth step in New job and execute? |
|
|
|
shanmp
Starting Member
13 Posts |
Posted - 2009-01-07 : 23:26:09
|
| I cant create the job as I dont have permission to create or sp in the environment. So, please let me know which would be sufficient to run the fourth step. |
|
|
|
|
|
|
SQL Job - run steps individually