Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 run job sql 2000 and 2008

Author  Topic 

inbs
Aged Yak Warrior

860 Posts

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

thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-07-03 : 12:31:41
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

860 Posts

Posted - 2012-07-03 : 13:50:59
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

38200 Posts

Posted - 2012-07-03 : 13:55:26
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

860 Posts

Posted - 2012-07-03 : 15:33:01
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

38200 Posts

Posted - 2012-07-03 : 15:45:18
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
   

- Advertisement -