Versions Compared

Version Old Version 3 New Version 4
Changes made by

Keith Mangold

Alex Hatzopoulos-A (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info
titleSQL to Enable E-Mails from Scheduler
SET IDENTITY_INSERT [dbo].[Schedule] ON;
 
BEGIN TRANSACTION; 
INSERT INTO [dbo].[Schedule]([ScheduleID], [TaskTypeID], [ScheduleDesc], [ExecuteTime], [IntervalTypeID], [IntervalUnits], [IsRecurring], [IsDeleted], [IsDisabled], [RowCreateDate], [RowModifyDate], [RowVersion], [TaskID]) SELECT 1, 1, N'Send E-Mail', '20110922 10:42:00.000', 1, 1, 1, 0, 1, '20110922 09:28:12.900', '20130321 13:44:56.490', 18, NULL 
COMMIT; RAISERROR (N'[dbo].[Schedule]: Insert Batch: 1.....Done!', 10, 1) WITH NOWAIT;
GO
 
SET IDENTITY_INSERT [dbo].[Schedule] OFF;

  

 By default the scheduled task is disabled. Update the Schedule tables bit for "IsDisabled" to false as soon as you want the task to become active. You may need to restart the scheduler for this task to be picked up.