• First try running the job using and see if it works then we can schedule it as a job ..

    USE msdb ;

    GO

    EXEC dbo.sp_start_job N'Job_Name' ;

    GO

    --

    SQLBuddy