I have looked at the data for the past 15 years. Some work like healthcare and IT are going up and some work like manufacturing are going down. The total amount of work is declining steadily at the speed of about 0,4% of population losing a job every year. This is not actual job loss, as I am looking at hours of work done and estimating the amount of jobs based on the hours, because some jobs are short term, some have only few hours etc.
Problem is not about inventing new jobs. Problem is finding new customers. Currently new customers come from the middle class increasing by about 250 million per year. But that can continue for only about 20 years in the best case scenario. After that there will no longer be growth in consuming. After that, every increase in automation will not mean new jobs, it will mean just job loss.
And this is the absolutely best case scenario I can think of. I still think that most realistic scenario is that it will be just downhill from here on.