Home Forums SQL Server 2012 SQL 2012 - General Job fails on first Wednesday of every month RE: Job fails on first Wednesday of every month
peter.cox
Ten Centuries
Points: 1067
More actions
June 26, 2014 at 7:54 am
#1725085
funnily enough i've had both
option (OPTIMIZE FOR (@StartDate UNKNOWN, @todayinJulian UNKNOWN),MAXDOP 12)
and
option (RECOMPILE,MAXDOP 12)
on there (not at the same time, obv). It happened no matter what.