Hi all,
I cannot get the GetDate() function to work in a query. I have the code for a brilliant SQL job query written by another user. It lists all jobs and their status.
I want to list all jobs other than succeeded and this works fine but I also want to only list the ones for the last 48 hours. You can see near the bottom I have added the GetDate but it refuses to work.
Can one of you experts tell me what I am doing wrong?