static void Main(string[] args) { var client = new DelayTaskClient(new IPEndPoint(IPAddress.Loopback, 12306)); // 20 秒后删除SqlDelayTask表内的所有数据 var task = new SqlDelayTask { ID = Guid.NewGuid(), Name = "SQL任务1", Description = "这是一个测试SQL任务", ExecuteTime = DateTime.Now.AddSeconds(20), ConnectingString = "Data Source=.;Initial Catalog=DelayTask; Persist Security Info=True;User ID=sa;Password=123456", SqlCommand = "DELETE FROM [SqlDelayTask]" }; var state = client.SetSqlTask(task).Result; Console.WriteLine("设置任务{0}", state ? "成功" : "失败"); Console.ReadLine(); }
public bool SetSqlTask(SqlDelayTask task) { return(TaskSheduler.SqlTaskTable.Set(task)); }