Test Cases Question:

How to test a stored procedure?


There are two ways to test a stored procedure.

1)Black box testing: The Result Set should be checked if the
desired output is returned by SQL command.

2)Performance Testing: Stored Procedures are created to
avoid compiling it again and again. hence, testing should be
done to check if stored procedures are reducing CPU load and
network traffic.

Previous QuestionNext Question
Suppose a job should be executed for every two hours? Write test case for this?Write test cases for this scenario if a job fails it should get restarted again this should happen for three times if it fails again then it should quit?