are sql stored procedure asynchronous?
I created the stored procedure using job object of SQL server agent. You can run the sql command asynchronously directly from SQL, from another stored procedure, task or another sql server command or from external ASP/ASP Net application.