wwwnlc111 (5/4/2016)
Hi,I need to show SQL job execution for last 30 days at what time, this mean I have Date and time.
Now question how I can take Time (hh:mm) for aggregations, it's bit challenging but crazy :w00t:
Thanks.
probably better to post a new question...this thread is a few years old and relates to reporting services.
but if you are specifically asking about SQL Agent execution times....this post may help
https://www.mssqltips.com/sqlservertip/2850/querying-sql-server-agent-job-history-data/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day