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);
}
