Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

Identify running jobs on remote server

Jun 20 2011 5:48AM by Manas Ranjan Dash   

To identify running jobs in a remote server we can use sphelpjob command in the following way.

--Content of sqlQuery.sql
exec msdb.dbo.sp_help_job @execution_status = 0
--Main Code to execute.
 sqlcmd.exe -S<servername> -U<username> -P<password> -dmsdb -h-1 -b -i sqlQuery.sql
Read More..   [0 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


Manas Ranjan Dash
39 · 5% · 1484
2
 
1
 
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

Your Comment


Sign Up or Login to post a comment.

"Identify running jobs on remote server" rated 5 out of 5 by 2 readers
Identify running jobs on remote server , 5.0 out of 5 based on 2 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]