Posted on: 2/10/2014 11:23:43 PM | Views : 650

Hello

I have created one batch which will run after every 5 minute & Delete Some Data from table based on some condition.

Code is 
DELETE FROM MyLoginUser WHERE DATEDIFF(MINUTE,LastUpdateTime,(select CURRENT_TIMESTAMP)) > 5
That is working Fine No issue.
But One of our client uses SqlExpress Edition. In that I found that There is no Sql Agent Functionality. SO I think Batch is not DIrectly suported.

So Can anyBody Guide me how to achieve this kind of Batch Schedule in sql Express?

Thanking you in advance.

Regards
Vipul Langalia

Go to the complete details ...