创建定时任务视图 vw_ScheduledTaskView

创建视图 vw_ScheduledTaskView as select t.UserID as 用户ID, u.UserName as 用户名, t.TaskName as 任务名称, t.TaskDescription as 任务描述, t.ExecutionTime as 执行时间, d.DeviceName as 设备名称, ds.StatusName as 状态名称 from ScheduledTask t inner join userb u on t.UserID = u.UserID inner join Device d on t.DeviceID = d.DeviceID inner join DeviceStatus ds on t.StatusID = ds.StatusID;