Thank You gazareth.

Great help indeed

Yeah gazareth given a superb query.

Actually my requirement is.

The jobs status should only show for present day. and the jobs which are currently executing also.Irrespective of the yesterdays run status.

I...

Thanks for the replies.

I want to run this query as a report(rdl) and make available to other team member as well.:-) so that my seniors should not come to me...

Hi Ganesh,

Thanks for the response.

Actually we have 10 tables around 18millions rows average on each table. If we run that job after deleting all the rows its working fine.

If data...

Thanks it solved my problem too

Hey buddy

u cant find now the user. but for future create sql audit specification for that server.