private string GetOldJobsSql() { return("Select * from " + JobsQueueTable + " where Printed = '1' and ( DATEDIFF( minute , AddedDate, GETDATE() ) >= " + Config.GetDeleteInterval() + " )"); }
private string GetJobQueueSql() { string sSql = "Select Top 1 * from " + JobsQueueTable + " where Printed = '0' and GETDATE() > DateAdd(s, " + Config.GetSelectDelay() + ", AddedDate) order by AddedDate"; return(sSql); }