InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 15:59:33 GMT20http://www.sqlservercentral.com/Forums/Topic1356945-1550-1.aspx[quote][b]iRobot (9/18/2012)[/b][hr]I cannot figure out which table to get information for the next scheduled Job.Would it be dbo.sysschedules -active_start_date,active_start_timeORdbo.sysjobschedules- next_run_date,next_run_time?[/quote]Yes, next_run_date and next_run_time will give you what you are looking for. Be aware though that the time field is in Integer format, and won't have leading zeros, so you will have to pad the output if you are making any type of report.Hope this helps.Wed, 19 Sep 2012 06:13:14 GMTSodtkehttp://www.sqlservercentral.com/Forums/Topic1356945-1550-1.aspxI cannot figure out which table to get information for the next scheduled Job.Would it be dbo.sysschedules -active_start_date,active_start_timeORdbo.sysjobschedules- next_run_date,next_run_time?Tue, 18 Sep 2012 16:11:49 GMTiRobothttp://www.sqlservercentral.com/Forums/Topic1356945-1550-1.aspxIs there a way to figure out which tables are affected by which jobs?Fri, 14 Sep 2012 13:04:16 GMTiRobothttp://www.sqlservercentral.com/Forums/Topic1356945-1550-1.aspxThat sounds great! Could you please post it?ThanksWed, 12 Sep 2012 06:36:59 GMTiRobothttp://www.sqlservercentral.com/Forums/Topic1356945-1550-1.aspx[quote][b]iRobot (9/11/2012)[/b][hr]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.[/quote]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.Wed, 12 Sep 2012 01:44:59 GMTsql.comhttp://www.sqlservercentral.com/Forums/Topic1356945-1550-1.aspxAhmed,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.Tue, 11 Sep 2012 06:48:17 GMTiRobothttp://www.sqlservercentral.com/Forums/Topic1356945-1550-1.aspxThis might answer your question[url=http://www.sqlservercentral.com/Forums/Topic1292959-148-1.aspx#bm1293762][/url]or this onehttp://www.sqlservercentral.com/Forums/Topic1085386-391-1.aspx#bm1085485Almost all database monitoring tools provide interface for Job monitor.Mon, 10 Sep 2012 19:31:10 GMTultimate sqlhttp://www.sqlservercentral.com/Forums/Topic1356945-1550-1.aspxWe have a large number of jobs running on SQL DB servers. Is there a tool to find out what is actually running and what they all do? Management want all this to be documented. We are using sql server 2008r2.Any thoughts?Mon, 10 Sep 2012 12:16:49 GMTiRobot