SQL Server Performance Forum – Threads Archive

The maximum number of SQL jobs

Please tell me the maximum number of SQL jobs we can create in MS SQL Server 2000. Thank you very much.

---

Hi,<br />The maximum number of databases that a single SQL Server installation can hold<br />is 32767….<br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />

---

Hemant, I think space availability is the limit rather than 32767. Correct my if I am wrong. -Johnson

---

Hi,<br />yes but no of objects can be maximum of 32767 and offcourse space is also in count .<br /><br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />

---

ok thanks, But I have read something else in BOL, but its about number of tables
———
Search for "number of tables per database" in BOL SQL Server can have as many as two billion tables per database and 1,024 columns per table. The number of rows and total size of the table are limited only by the available storage. ———-
I think jobs are also objects like jobs. Is this true? -Johnson

---

What kind of jobs you’ve currently?
How many numbers you need to create?
If you are having any issues with current jobs then refer to the SQLAgent log and SQL Server error log for more information or specify the problem to get a solution.
Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>