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]