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 jobs

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-05-19 : 07:39:10
Than writes "Does anyone know how many steps can we add in one job in the MS sql 2000. Is there any limit?"

mr_mist
Grunnio

1870 Posts

Posted - 2005-05-19 : 07:52:43
Well the steps are held in a table with a jobstep id that is an INT, so presumably the maximum number of steps would be 2,147,483,647. Whether that would be pratical or not is down to you.

-------
Moo. :)
Go to Top of Page
   

- Advertisement -