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
 Site Related Forums
 Article Discussion
 Article: Controlling Jobs in Transact-SQL

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-09-16 : 20:34:49
We've had a couple of questions about "fire and forget" processing and exporting data to alternative formats. One of the easiest way to accomplish these tasks is using JOBS. They can easily be set up and executed from within Enterprise Manager and just as easily controlled from Transact-SQL.

Article Link.

deepblue
Starting Member

2 Posts

Posted - 2001-12-04 : 11:28:57
Try msdb..sp_start_job

d:-)

quote:

missing sp_start_job and all other sp's related to SQL Server Agent ? <P>Hello,
In SQL 7 and SQL 2000 Beta we have, we don't see any of those SQL Server Agent stored procedures. What's wrong ? We have Enterprise versions of SQL.



Go to Top of Page
   

- Advertisement -