Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Governing SQL Server agent jobs across SQL instances Expand / Collapse
Author
Message
Posted Tuesday, November 5, 2013 2:47 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:44 AM
Points: 82, Visits: 245
Hi, I'm searching a software that allows to govern or orchestrate SQL Server agent jobs
distributed on more SQL Server instances.
With a such tool, I could establish that a certain job must start after the execution of another job.
Post #1511648
Posted Tuesday, November 5, 2013 5:30 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, July 24, 2014 4:49 PM
Points: 4,065, Visits: 5,277
We've just purchased a product called JAMS from MVP Systems that is able to manage SQL Agent jobs as well as Windows jobs. We're starting out by using it to manage Windows batch jobs, so haven't tried it with SQL jobs yet.

Greg
Post #1511678
Posted Tuesday, November 5, 2013 9:56 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:44 AM
Points: 82, Visits: 245
Hi Greg, thanks for your answer.
Have you a link and/or major details to provide me?
Moreover, do you know if the does solution allow to orchestrate the SQL Server agent job as a workflow?

Thanks
Post #1511712
Posted Wednesday, November 6, 2013 10:29 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, July 24, 2014 4:49 PM
Points: 4,065, Visits: 5,277
Sure. http://www.jamsscheduler.com/Default.aspx
According to the documentation, JAMS does support workflow. Good Luck!


Greg
Post #1511949
Posted Wednesday, November 6, 2013 10:44 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 2:13 PM
Points: 206, Visits: 2,034
Another such product is Skybot, www.skybotsoftware.com. It claims to run across multiple platforms, such as SQL Server, Oracle, SAP, etc.
Post #1511958
Posted Wednesday, November 6, 2013 10:12 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 20, 2013 1:51 PM
Points: 5, Visits: 62
You can try Control-M
Post #1512084
Posted Thursday, November 7, 2013 12:38 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:44 AM
Points: 82, Visits: 245
Control-M by BMC Software, isn't it?
Thanks
Post #1512115
Posted Thursday, November 7, 2013 1:52 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:20 PM
Points: 112, Visits: 802
Another is "Tidal enterprise scheduler" it is compatible with unix/linux also.

It's great product, I can't speak on the others suggested but this one allows for dependencies on jobs regardless, sql, dos, windows, unix, etc.. It was bought by Cisco more recently.



--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully
Post #1512140
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse