task management project

Question

hello sir

 

   i have assign the task on user(morning shift,evening shift).

   mornning shift pending task automatically assign the evening shift of user using sheduled task in sql server 2008 r2

   

 waiting for your answer 

please help me

 

 

Regards

Selastin c