You are a database developer for a hospital. There are four supply rooms on each floor of the hospital, and the hospital has 26 floors. You are designing an inventory control database for disposable equipment. Certain disposable items must be kept stored at all times. As each item is used, a barcode is scanned to reduce the inventory count in the database. The supply manager should be paged as soon as a supply room has less than the minimum quantity of an item. What should you do?

241.

You are a database developer for a hospital.
There are four supply rooms on each floor of the hospital, and the hospital has 26 floors.
You are designing an inventory control database for disposable equipment.
Certain disposable items must be kept stored at all times.
As each item is used, a barcode is scanned to reduce the inventory count in the database.
The supply manager should be paged as soon as a supply room has less than the minimum quantity of an item.

What should you do?

Create a FOR UPDATE trigger on the inventory table. If the quantity in the inserted table is less than the restocking quantity, use the xp_sendmail system stored procedure to page the supply manager.

Create a stored procedure that will be called to update the inventory table. If the resultant quantity is less than the restocking quantity, use the xp_logevent system stored procedure to page the supply manager.

Create an INSTEAD OF UPDATE trigger on the inventory table. If the quantity in the inserted table is less than the restocking quantity, use SQLAgentMail to send an e-mail message to the supply manager’s pager.

Schedule the SQL server job to run at four-hour intervals.
Configure the job to use the @notify_level_page = 2 argument. Configure the job so that it tests each item’s quantity against the restocking quantity. Configure the job so that it returns a false

View Description

No description found.