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 ...