Dear SQL server gurus,

I have created a job a year ago with more than 20 steps. Now when I check
the job property, select Steps tab, the steps are now out of order.
I have many jobs but only one job has its steps out of order. It does not
effect its function - I guess - but I have no idea why it happened

Does anyone have any idea why it happened.

TIA.

Hai

SQL DMO has a known bug which will scamble the job step order of a job that has been imported or exported between servers

"Hai" wrote:

I have also seen this on jobs that have never been anywhere except for the
server on which they sit. I agree that this is a nuance of the view and
have something at the back of my head to say I have read/seen something
somewhere about it. Like the OP says though, this does not affect the job
itself.


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Richard S. Hale" <RichardSHale (AT) discussions (DOT) microsoft.com> wrote

Its because sp_help_jobstep doesn't contain an order by.
Usually you get the right order on the results but it's not
guaranteed.
I only remember what the issue is - but can't remember where
I read or heard about it either.

-Sue

On Thu, 22 Jul 2004 06:14:11 +0100, "Allan Mitchell"
<allan (AT) no-spam (DOT) sqldts.com> wrote: