check if query executes in give span of time

Question

Dear All

 

How can i check if my query is getting executed in give span of time else i need to terminate query and update something

 

For example

 

Select * from tablename

wait only say 30 sec for this query to execute 

if gets completed else do some other task

 

Do anyone have idea about this