Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Third Party Scheduling of SQL Server Jobs

Status
Not open for further replies.

Apollo21

Programmer
May 2, 2003
70
US
We utilize Control-M to schedule all of our production jobs.

I would like to include the SQL Server Maintenance Plan Jobs within that product. I do it now with MSDE and I would like to implement with SQL Server 2000 & 2005.

I imagine there are different ways of accomplishing this. Does anyone have any ideas or proven implementations of doing this with SQL Server Standard 2000 & 2005.

Thank you in advance !!!
 
Take the command line path that would normally be run by the SQL Server (in SQL 2000 this'll be the xp_sqlmaint call, and in SQL 2005 it'll be an SSIS package) and setup your third party scheduler to run these commands either via osql, sqlcmd, DTExec, etc (what ever is called for).

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top