iRobot (9/11/2012)
Ahmed,I am not a DBA and haven't actually used any of those tools. But I came across some great queries which will provide SQL Agent Jobs and schedules related information.
http://www.mssqltips.com/sqlservertip/2561/querying-sql-server-agent-job-information/
If I could just set up some interface wouldn't it do the job?
What would be your input on this? Please advise.
I have used queries similar to what you have posted but converted them to SSRS so we have a central point to view whats going on at a server level regarding agent jobs. Can get interesting and handy when needing to pivot of a certain day, drilling down on job X etc.