Breast Biopsy

I scheduled a Breast biopsy on Wednesday for a lump in my breast. I have never gotten one before and wanted to know will I need to call off from work afterwords? Will I be in pain the whole day? And is it scary?