There is job for dataload in my production server. Someone(anyother DBA) mistakenly executed that job an then cancelled the job within few seconds. Then he\she cleared job history using GUI for the same job. My questions are :- Is there any query to know who deleted that job history? Is there any location on msdb from where i can retrieve complete job history(even deleted ones) since its first execution to know who executed that job?
If you have backed up the msdb (as you should do), you can restore it (under a different name) and recover the job history from there. As far as knowing who cleared the history; that is not recorded anywhere by default. You would have had to have a trace running to make note of that process being run. This is something you have to program yourself, so if you didn't have it, you have no way of knowing now.