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 |
|
getur.srikanth@gmail.com
Yak Posting Veteran
77 Posts |
 Posted - 2009-10-13 : 10:15:43
|
| The On Success action of the last Step will be changed from 'Goto Next Step' to 'Quit with Success'.Is this the intended behavior?I am getting this warning windows after removed last step from the job. Is this cause any problem? How to remove this? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-13 : 10:26:29
|
Have a look at your jobsteps before you delete the last one.You can see a kind of jobflow.Each step says: goto next step when successful completed but the last step cannot goto a next step because there is no next step.Hence, the last step says: quit with successNow if you remove the last step then there is a new one the last step formerly not known as last step. And this step says: goto next step - thats now impossibleSo the system says: I will do your job and correct this - is it ok for you?So everything is fine.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
getur.srikanth@gmail.com
Yak Posting Veteran
77 Posts |
Posted - 2009-10-13 : 10:37:15
|
| Thats true, I just removed last step and I am getting warning window. If I run this job. The job was failed."The job failed. JobManager tried to run a non-existent step (2) for job NewUserstoAdd."So it is still expecting step(2) after deletion. Where can change this? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-13 : 10:50:44
|
In the window where you can see the jobsteps.There is drop down or so there you can choose quit with success.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
getur.srikanth@gmail.com
Yak Posting Veteran
77 Posts |
Posted - 2009-10-13 : 11:07:24
|
| Thanks dude. It works. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-13 : 11:31:45
|
welcome 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
After removing last step from the job... error