SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 After removing last step from the job... error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

getur.srikanth@gmail.com
Yak Posting Veteran

77 Posts

Posted - 10/13/2009 :  10:15:43  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

Germany
8766 Posts

Posted - 10/13/2009 :  10:26:29  Show Profile  Visit webfred's Homepage  Reply with Quote
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 - 10/13/2009 :  10:37:15  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

Germany
8766 Posts

Posted - 10/13/2009 :  10:50:44  Show Profile  Visit webfred's Homepage  Reply with Quote
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 - 10/13/2009 :  11:07:24  Show Profile  Reply with Quote
Thanks dude. It works.

Edited by - getur.srikanth@gmail.com on 10/13/2009 11:07:48
Go to Top of Page

webfred
Flowing Fount of Yak Knowledge

Germany
8766 Posts

Posted - 10/13/2009 :  11:31:45  Show Profile  Visit webfred's Homepage  Reply with Quote
welcome


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000