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 Development (2000)
 Dynamic changes to Job step is not working

Author  Topic 

Rajeswari
Starting Member

20 Posts

Posted - 2001-11-22 : 01:09:09
Scheduling the Jobs.

I scheduled the job with 2 steps, both the steps call the stored procedures using TSQL.
In the first step i am updating the step 2(changing the transact SQL). Job runs successfully, but it is not taking the updated step2.

when i open the job through enterprise manager, i am able to see the changes in step 2. Internally how job schedule works, whether it takes all the steps into the buffer and starts running?.
   

- Advertisement -