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 2005 Forums
 Transact-SQL (2005)
 SQL Server Job

Author  Topic 

Lijo Cheeran Joseph
Posting Yak Master

123 Posts

Posted - 2010-03-18 : 13:51:37
Hi Team

I am planning to include a stored procedure into an existing SQL Server job. I would like to know the constraints for a SQL Server Job.

Could you please list the constraints of SQL Server Jobs, that we must be aware, while writing SPs for jobs?


1) Is there any limit on the number of SPs used?
2) Is there any constraint that temp table cannot be used?
3) Or any other constraint.

Experts, please help..

Thanks
Lijo Cheeran Joseph

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-18 : 14:13:24
There aren't any limitations. Whatever you are planning to do with the stored procedure/temp table will work fine in a SQL Agent job.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -