• Hi

    Under SQL Server Agent --> Jobs - you can right-click on Jobs and say New Job

    Step 1: Give the Job a Name

    Step 2: Click on Steps

    Step 3: Click on New

    Step 4: Give this step a name

    Step 5: Select Database (can you master for testing)

    Step 6: In the command type: select 'Step 1 of my Job'

    Step 7: Click OK

    Step 8: Click on Schedules

    Step 9: Click on New

    Step 10: Click on New

    Step 11: Type a name for this schedule

    Step 12: Select Daily and every 5 minutes

    Step 13: Click OK

    Step 14: Click OK again

    you have just created a job with 1 step with a schedule

    To execute a stored procedure in the command as in Step 6 - you will replace the text with something like:

    exec sp_name

    let me know if this helps at all

    Thanks

    Kevin