Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

(Riga) Can I run a separate job step? Not the whole job? Expand / Collapse
Author
Message
Posted Tuesday, June 17, 2008 8:42 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, June 28, 2011 12:06 PM
Points: 557, Visits: 775
I have job on SQL Server 2000.
Can I run a separate job step? Not the whole job?



Post #518320
Posted Tuesday, June 17, 2008 8:50 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 7:04 AM
Points: 1,030, Visits: 2,795
If you access the job through EM and the agent you shouild be able to open the job, then right click and exeute the step in question.

Gethyn Ellis

gethynellis.com
Post #518329
Posted Tuesday, June 17, 2008 9:39 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, June 28, 2011 12:06 PM
Points: 557, Visits: 775
If you right-click the job in EM
you have:

New Job
Start Job
Stop Job
Enable Job
View Job History...
Refresh Job
All Tasks >Generate SQl script
Delete
Properties
Help

Where should I go to execute a specific Job Step?




Post #518386
Posted Tuesday, June 17, 2008 10:19 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 1:03 PM
Points: 4,064, Visits: 5,317
When you right-click on the job and select 'Start Job', you'll be able to choose the step you want to start, if it's a multi-step job.

Note that the job will start at the step you specify and run any steps after that depending on the on success/failure flow for each step. You can't run just one step without disabling that flow first. For example, if the job has 3 steps and you only want to run the first one, you'd have to disable the on success/failure flow for that step so it wouldn't run steps 2 and 3.


Greg
Post #518411
Posted Tuesday, June 17, 2008 11:28 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, June 28, 2011 12:06 PM
Points: 557, Visits: 775
Thanks. I figured it out.
Is there a T-SQL code to do the same thing?



Post #518453
Posted Tuesday, June 17, 2008 10:39 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 6:23 AM
Points: 1,101, Visits: 5,288
sp_start_job
Post #518736
Posted Saturday, June 21, 2008 11:08 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 1:31 PM
Points: 416, Visits: 573
Yes thats right, You can use Sp_start_job on MSDB database!

eg.)
sp_start_job @job_name='your jobname'



Regards..Vidhya Sagar
SQL-Articles
Post #521377
Posted Monday, June 23, 2008 5:13 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 1:03 PM
Points: 4,064, Visits: 5,317
Specifically, it would be

sp_start_job @job_name='your jobname', @step_name = 'your stepname'


Greg
Post #522260
Posted Wednesday, January 1, 2014 4:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 12, 2014 12:00 AM
Points: 1, Visits: 86
Thank You.... Greg Charles...
Post #1526898
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse