On the SQL Server Build Lists page, the links to the 2016 and 2017 builds appear to be broken.

September 25, 2018 at 1:52 am

#2006859

This should get you started ...
WITH cteSourceData AS (
SELECT jobid
   , info = CAST(info AS xml)
FROM mytable
--WHERE jobid =...

You could also create a re-usable function

CREATE FUNCTION dbo.GetJulianDate(
@SomeDate datetime
)
RETURNS TABLE WITH SCHEMABINDING
AS RETURN
SELECT JDate = YEAR(@SomeDate)*1000 + DATEPART(dayofyear,@SomeDate);

This will give you the current date in the format YYYYDDD
SELECT YEAR(GETDATE())*1000 + DATEPART(dayofyear,GETDATE());