Check out this post File download counting
If that doesn't help you, let me give you the logic on how to do that, and you can refer the other post for some help. Though if you are stuck up somewhere, we are there to help.
Instead of showing the link directly here, have a link to another asp file, with the same querystring along with JobId and username, say...
<a href="download.asp?Url=<%=objRS("url2")%>"&JobId== "<%=objRS("jobid")%>&UserName=<%=Session("user")%> ></A>
Then within download.asp, first insert these JobId, UserName and SystemDate into the respective table. Then refer to the my other post shown above for code to initiate the download popup, from where the user can download the file. Use the URL that comes along with querystring to the download.asp to pass to the downloadFile
function (code listed in the other post).
Also you don't need to use a hidden field there as used in your code.
As I am rushing up from work (end of the day) I couldn't explain in detail. Bear with me!:)
Hope that helps.
- Vijay G
Strive for Perfection