Re: SQL 2000 manual start job sort order

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: kevin (anonymous_at_discussions.microsoft.com)
Date: 06/23/04 

Date: Wed, 23 Jun 2004 06:05:15 -0700

Uri, up till last week, everything was fine. But now, if
I open the properties of the job, the steps are still
correctly listed in numerical order. But, if I try to
start the job manually, the dialog box opens and voila!
they're listed alphabetically by job step name. Weird.
I'm just wondering if this implies corruption in any way.
thanks
k
>-----Original Message-----
>Hi ,Vyas
>What is the procedure?
>EXEC sp_help_jobstep @job_name = 'Backup' seems to
returned a right order of
>steps ?
>
>"Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote
in message
>news:OQPHpBSWEHA.2168@TK2MSFTNGP10.phx.gbl...
>> I am not sure if this is in the KB, but it is a bug
with the stored proc
>> that returns the job steps. The developer forgot to
put an ORDER
>BY...oops!
>> --
>> HTH,
>> Vyas, MVP (SQL Server)
>> http://vyaskn.tripod.com/
>> Is .NET important for a database professional?
>> http://vyaskn.tripod.com/poll.htm
>>
>>
>> "kevin" <anonymous@discussions.microsoft.com> wrote in
message
>> news:204e101c4591e$1510a5c0$a101280a@phx.gbl...
>> Hello - I am wondering if anyone else experienced this:
>> Last week, one of my DBAs wanted to start a job
manually,
>> right-clicked on the job, got a step list back with
>> request to click on step to start on. Oddly enough,
the
>> list was not sorted numerically (as it usually is) but
>> alphabetically. How can this be fixed and does this
>> necessarily indicate any further problems? Thanks in
>> advance.
>>
>>
>
>
>.
>