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?