This is my 1st post in CODE PROJECT and new to C#.net(But i have Knowledge in C++ and VB).and started learning about c# and SQL server
I'm creating work allocation and TAT system, (we receive the Job tickets from customer each request has unique id,ticket tat end time )
i just created the windows form that import the excel from my pc and stores the data into SQL server(Table name:W_Allocation).this table have TAT start time,end time and Ticket status for each request.
What i'm expecting from you people is SQL needs to send a mail to me before 2 hour of TAT end time if the ticket status is pending
Someone said SQL Jobs can do this . But i have basic Knowledge in SQL and i dont know how to create SQL jobs programmatically from windows form.
Or is there any other way to do this, looking forward your responses,