To Execute a job from inside a stored procedure.

EXEC msdb.dbo.sp_start_job @job_name = 'Oracle_To_SQL'

Normally if the above statement is not used you will get an error like “The module depends on the missing object ‘sp_start_job’.”