SQL2K Agent Job Steps
in [Server Configuration]
|
Prev: send automatic information to my table on the second sql server 2005
Next: What will happen to transaction log if we take a full backup ?
From: Judy on 7 Mar 2010 18:32 Hi There, Did you manage to fix the Job Step order problem? and if so how please? I am currently having the same problem. Thanks Dav wrote: SQL2K Agent Job Steps 10-Oct-08 I am running SQL 2000 - SP4. When I right-click on Agent Job, and click on start, the job steps are in Step Name order, not Step ID order. When I go to Job Properties and Steps tab, steps are in Step ID order correctly. If I start the job, it does run in the correct step order. Seems to be just on the start job display. Any ideas or suggestions?? Previous Posts In This Thread: On Friday, October 10, 2008 10:43 AM Dav wrote: SQL2K Agent Job Steps I am running SQL 2000 - SP4. When I right-click on Agent Job, and click on start, the job steps are in Step Name order, not Step ID order. When I go to Job Properties and Steps tab, steps are in Step ID order correctly. If I start the job, it does run in the correct step order. Seems to be just on the start job display. Any ideas or suggestions?? On Tuesday, October 14, 2008 6:07 AM John Bell wrote: Re: SQL2K Agent Job Steps "Dave" <Dave(a)discussions.microsoft.com> wrote in message news:5CBD2C1A-5C28-478D-8140-81F2C197E5EE(a)microsoft.com... Hi Looking at profile seems to show that the query that supplies the data is ordered by [ID] ASC (the batch which creates #tmp_sp_help_jobstep to store determine the steps) although I am post SP4 9.00.3233.00. John Submitted via EggHeadCafe - Software Developer Portal of Choice Configure and send SMTP mail based on message content from within an orchestration http://www.eggheadcafe.com/tutorials/aspnet/4e9e7c92-1279-4fdb-8631-a2f309a021c2/configure-and-send-smtp-m.aspx |