Executing SQL Agent Job Remotely

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » Executing SQL Agent Job Remotely

Executing SQL Agent Job Remotely

Rate Topic

Display Mode

Topic Options

Author

Message

Rups

Posted Thursday, June 04, 2009 8:50 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 1:52 PM
Points: 360, Visits: 173

Hi,
I need to create a batch file for a user. This batch file will have to execute a Sql agent job on Remote Server.

I am not able to execute SQL Agent job using batch file remotely.
User's machine doesn't have sql server installed and we don't want to install it either.

Is it possible to execute a SQL Agent job from a Batch file out of Remote User's machine where we don't have SQL Server installed???

Thanks in advance.

-RP

-RP

Post #729021

spaghettidba

Posted Thursday, June 04, 2009 10:40 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:39 PM
Points: 4,804, Visits: 8,073

You could write a .VBS Script to connect to the server and issue msdb.dbo.sp_start_job @job_name = 'yourjobname'.

Hope this helps
Gianluca

Get your two-cent-answer quickly
The Spaghetti DBA

Post #729135

Rups

Posted Thursday, June 04, 2009 10:53 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 1:52 PM
Points: 360, Visits: 173

Ya, I can do that using VBS but they don't want it. they want it to be done by .bat or .cmd only.
Is it possible?

Thanks for your reply..

-RP

-RP

Post #729147

spaghettidba

Posted Friday, June 05, 2009 1:31 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:39 PM
Points: 4,804, Visits: 8,073

If you can't have a VBS, then you need something able to connect to SQL server and issue queries. One thing that comes to my mind is sqlcmd or osql. You can copy just the .exe to the client machine and then run it with the query as a parameter. I tried that with osql.exe and it worked, without installing anything on the client side.

Hope this helps
Gianluca

Get your two-cent-answer quickly
The Spaghetti DBA

Post #729450

spaghettidba

Posted Friday, June 05, 2009 2:39 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:39 PM
Points: 4,804, Visits: 8,073

You're incredibly lucky: take a look at today's articles:

http://www.sqlservercentral.com/articles/SQL+Job/66421/

Get your two-cent-answer quickly
The Spaghetti DBA

Post #729479

Rups

Posted Friday, June 05, 2009 8:39 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 1:52 PM
Points: 360, Visits: 173

Superb.

Excellent.
Thanks a lot for your help, even your post solved my issue, Article has nothing about remote machine without having sql client installed on it.
I copied that OSQL file on user's machine and tried to run it and it worked... "Bole to Jhakaas" means Outstanding in my language.

Thanks for your help again.

-RP

-RP

Post #729783

« Prev Topic | Next Topic »

Permissions