• I tried adding msdb.dbo.sp_add_jobserver to my start procedure

    ALTER PROCEDURE [dbo].[StartBookingReminders]

    -- Add the parameters for the stored procedure here

    @RunsEvery Int,

    @ServerName VARCHAR(30),

    @DatabaseName VARCHAR(128)

    AS

    BEGIN

    Exec dbo.StopBookingReminders

    exec msdb.dbo.sp_add_job @job_name = 'CS-Booking_Reminders',

    @enabled=1

    exec msdb.dbo.sp_add_jobstep

    @job_name = 'CS-Booking_Reminders',

    @step_name = 'Check for reminders to send',

    @subsystem = 'TSQL',

    @command = 'exec dbo.SendBookingReminders',

    @database_name = @databaseName

    exec msdb.dbo.sp_add_schedule

    @schedule_name = 'CS-Booking_Reminders_Schedule',

    @enabled = 1,

    @freq_subday_type = 8,

    @freq_type = 128,

    @freq_subday_interval = @RunsEvery

    exec msdb.dbo.sp_attach_schedule

    @job_name = 'CS-Booking_Reminders',

    @schedule_name = 'CS-Booking_Reminders_Schedule'

    exec msdb.dbo.sp_add_jobserver

    @job_name = 'CS-Booking_Reminders',

    @server_name = @ServerName

    END

    Haven't seen any results in the job history yet

    SELECT

    *

    FROM

    msdb.dbo.sysjobhistory AS JH JOIN

    msdb.dbo.sysjobs AS J

    ON JH.job_id = J.job_id

    WHERE

    J.NAME = 'CS-Booking_Reminders'

    [font="Arial"]Halfbubble ------------
    You just can't do this stuff unless you're at least half a bubble off center.[/font]