Issue:
We would like to be able to create a list of jobs each morning that were created on the previous day using a SQL Job.
Resolution:
The formula below will take the current date and subtract one day using the Creation_Date on the OE_Job records.
Select * From OE_Job
WHERE Creation_Date >= dateadd(day,datediff(day,1,GETDATE()),0)
AND Creation_Date < dateadd(day,datediff(day,0,GETDATE()),0)
