This scripts I prepared for myself as I need to take full backup along with transaction log backup using single job and I found its working perfectly.
Create Job --> Step 1 --> Edit with EXEC [dbo].[GetDetails_Test]
Then schedule it for hourly basis.
Thanks, Nitin Gupta (SQL DBA - 2000/2005/2008)