我编写了一个脚本,从msdb.dbo.sysschedules读取作业计划,并运行sp_update_schedule来更改给定作业子集的active_start_time。在每种情况下,sp_update_schedule都会失败,因为消息“指定的@schedule_id('xxx')不存在”。(MessageID 14262,严重程度16)
schedule id in sysschedules不是它想要的吗?我在这里错过了什么?
debug: /Schedule[never]: Skipping device resources because running on a hostdebug: /Schedule[monthly]: Skipping device resourcesbecause running on a host
debug: /Schedule</