If what you have is acute sciatic nerve pain then the sciatic nerve pain should go away within 8 weeks.
If the sciatic nerve pain is not acute sciatic nerve pain then it can last longer than 8 weeks.
And if the sciatic nerve pain lasts longer than 8 weeks then you should seek medical attention for the sciatic nerve pain.