SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 run job sql 2000 and 2008
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

inbs
Aged Yak Warrior

811 Posts

Posted - 07/03/2012 :  03:58:32  Show Profile  Reply with Quote
i want to execute job in 2008 by 2000 and opposite,how can i do it?

thanks

tkizer
Almighty SQL Goddess

USA
35007 Posts

Posted - 07/03/2012 :  12:31:41  Show Profile  Visit tkizer's Homepage  Reply with Quote
sp_start_job?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

inbs
Aged Yak Warrior

811 Posts

Posted - 07/03/2012 :  13:50:59  Show Profile  Reply with Quote
but how is it work in sql 2000 (when i want to execute job in 2008?)
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35007 Posts

Posted - 07/03/2012 :  13:55:26  Show Profile  Visit tkizer's Homepage  Reply with Quote
Are you referring to SQL Server client tools? I'm really not understanding you.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

inbs
Aged Yak Warrior

811 Posts

Posted - 07/03/2012 :  15:33:01  Show Profile  Reply with Quote
i have two jobs:
job_A in sql 2000
job_B in sql 2008

i want that Job_A execute Job_B (that mean one step from job in sql 2000 will execute job_b sql 2008)

is it understood now?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35007 Posts

Posted - 07/03/2012 :  15:45:18  Show Profile  Visit tkizer's Homepage  Reply with Quote
You would use a linked server and execute sp_start_job.

Add the linked server on the 2000 server, it'll point to the 2008 server. Then in the job on the 2000 server, use this:

EXEC 2008LinkedServerNameGoesHere.msdb.dbo.sp_start_job ...

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000