Hi,

My broker service is configured to use a particular stored proc as the
Activation procedure.  It basically inserts some data into a table, then
runs sp_start_job to fire off a sql job (this all takes place on a single
SQL Server).  When the queue receives its message, the procedure runs great.
However the sp_start_job is not running the job, yet there is no indication
of any error.  The job simply doesn't run..  If I manually run the code in
the proc, the job fires off, so I'm fairly certain the code is syntactically
correct.  Would there be any security concerns that I should obvserve when
having the activation stored proc run something like sp_start_job?  anything
else that would prevent the job from starting up?

thanks.