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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 After removing last step from the job... error

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 success

Now 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 impossible

So 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.
Go to Top of Page

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?
Go to Top of Page

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.
Go to Top of Page

getur.srikanth@gmail.com
Yak Posting Veteran

77 Posts

Posted - 2009-10-13 : 11:07:24
Thanks dude. It works.
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -