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)
 Trigger Job From Stored Proc

Author  Topic 

jtwork
Yak Posting Veteran

82 Posts

Posted - 2008-03-28 : 12:49:56
s it poaaible? as if so how can i trigger a job from a stored procedure?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-03-28 : 13:34:54
Didnt understand the need for such a requirement? Usually its the other way round i.e job executing a procedure.
Go to Top of Page

mandm
Posting Yak Master

120 Posts

Posted - 2008-03-28 : 14:13:48
Check out sp_help_job and sp_start_job in BOL. That should get you going.
Go to Top of Page
   

- Advertisement -