USC Marshall School of Business is seeking someone with SQL experience to diagnose and repair some Stored Procedures that are failing. This is a short term gig, not a position opening.
I don't have all the details but from what I understand, there are some stored procedures and some are working and some are not. It sounds like there isn't any error handling to make sure that one procedure finishes before moving on to the next, or to throw an error if something fails.
Since I know nothing about stored procedures in SQL I'm not sure it's possible to use error handling in SQL stored procedures like you might in most other programming languages, I only know that it's not a case of all procedures are failing, only a few. I can put you in contact with someone who can explain further.
Rick Pine