Below works, updating the value
to 2012-03-15 09:17:24.910
How can I change so it always
keeps the end as "02:00:00.000" ?
update [ReportServer].[dbo].[Schedule]
--set [StartDate] = '2012-03-30' + substring([StartDate],11,13)
set [StartDate] = CURRENT_TIMESTAMP,
[NextRunTime] = CURRENT_TIMESTAMP
where [Name] like 'EOM - 3:30a%'
SET
[StartDate] = CONVERT(char(8), CURRENT_TIMESTAMP, 112) + ' 02:00:00.000',
[NextRunTime] = CONVERT(char(8), CURRENT_TIMESTAMP, 112) + ' 02:00:00.000'
WHERE
[Name] LIKE 'EOM - 3:30a%'