Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We have a SQL Agent Job that performs a few tasks every night (schedulled to run using SQL Agent). The database server is SQL 2012 if that makes a difference.

We have another process (a .net program) that needs to run on a different server after the job has finished on each server. The program cannot be installed on the database server.

Is there a way to get a SQL Agent Job to run a program on another computer after it has finished, or is there an easy way to indicate to a program on another computer that the job has finished?

share|improve this question

1 Answer 1

up vote 0 down vote accepted

You can do it using

you cam have a batch file call your program and can use xp_cmdshell (if allowed) or operating system task in SQL agent job to run the job locally. This job can be called using linked server or powershell after the main step in the original job is completed.

share|improve this answer
    
Powershell works great for me. Thanks –  Greg Oct 8 '13 at 2:59

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.