I have this scenario where I would like to update this one table by updating one of its column values.
UPDATE test_business_calendar
SET is_test_consolidate_date = 'Y'
WHERE business_date = '2016-11-24'
. Somehow I read SQL job in CA where it can only execute query and save the output only. I was wondering if SQL Job can achieve this