Link to home
Create AccountLog in
Avatar of Richard Comito
Richard ComitoFlag for United States of America

asked on

Can I use EXEC sp_start_job in a Stored Procedure?

I have a stored procedure in a database called Impresario.   What I would like to do is use sp_start_job within this stored procedure.  But because sp_start_job is an object in msdb and not Impresario, I would have to use USE msdb which is not allowed inside a Stored Procedure. So is there another way to execute sp_start_job at the end of my stored procedure in the impresario DB?

Thanks,

GabicusC
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account