Error - Lock Request Time Out Period Exceeded' error when running the Database Query step of a task

This error suggests that the SQL server was not allowing the task to be run due to a lock on a table. Try running the task manually to see if this lock has cleared and the task can now run.
​
If this happens frequently, it may be that the task is scheduled to run at a time when the SQL server is busy. It may be a good idea to schedule it to another time to avoid clashes.