added new stored procedure for updating the machine status