Change it to
CREATE PROCEDURE [Update_Datawarehouse] AS
EXEC msdb.dbo.sp_start_job @job_name = 'TRUNCATE DATAWAREHOUSE TABLES'
EXEC msdb.dbo.sp_start_job @job_name = 'PROPHECY TO DATAWAREHOUSE IMPORT'
>Hi All:
> I want to execute my jobs from the stored procedure I created.
>Here is my code
>
>CREATE PROCEDURE [Update_Datawarehouse] AS
>
>USE msdb
>EXEC sp_start_job @job_name = 'TRUNCATE DATAWAREHOUSE TABLES'
>EXEC sp_start_job @job_name = 'PROPHECY TO DATAWAREHOUSE IMPORT'
>
>I get an error 154, which reads" a USE database statement is not allowed in a procedure or trigger."
>
>Thus, my questions is how can I execute a job from stored procedure?
>Thanks
>MA
--sb--