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 2000 Forums
 SQL Server Administration (2000)
 SQL Job Steps out of order ?

Author  Topic 

js_elagto
Starting Member

3 Posts

Posted - 2008-09-26 : 11:46:03
I have a strange issue showing up on a SQL 2000 SP4 server. I have many jobs that have mulitple steps. The jobs seem to be executing without any issues. However when I right click on the job and choose to start the job. The steps appear to be in alphabetical order rather than step order.

This appears to be more of a cosmetic issue than a functional issue, still it is a bit concerning as this is a recent build of this server.

Any suggestions would be greatly appreciated

Thanks,
John

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-26 : 11:59:45
is it running in same order? i.e alphabetically? or is problem only in display order of steps in job history?
Go to Top of Page

js_elagto
Starting Member

3 Posts

Posted - 2008-09-26 : 14:07:42
It is running in the proper order, just displaying wrong.

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-26 : 14:14:21
quote:
Originally posted by js_elagto

It is running in the proper order, just displaying wrong.




thats because somebody has selected order by step name option in history window.
Go to Top of Page

js_elagto
Starting Member

3 Posts

Posted - 2008-09-26 : 14:38:16
Where exactly is that configured? I don't see where that can be changed.

Thanks,

quote:
Originally posted by visakh16

quote:
Originally posted by js_elagto

It is running in the proper order, just displaying wrong.




thats because somebody has selected order by step name option in history window.

Go to Top of Page
   

- Advertisement -