ratinakage
Programmer
Hi all.
I am trying to update the last job step in a job, before adding a final job step to the end of the job. In the below example, the last job step number is 5. but this is not always the case. Is there a way to ask SQL to update the last job step??
Thanks.
exec msdb..sp_update_jobstep @job_name = N'The Office - Batch Process - Data Summary Base Tables',
@step_id = 5,
@on_success_action = 3 ,
@on_fail_action = 3
GO
I am trying to update the last job step in a job, before adding a final job step to the end of the job. In the below example, the last job step number is 5. but this is not always the case. Is there a way to ask SQL to update the last job step??
Thanks.
exec msdb..sp_update_jobstep @job_name = N'The Office - Batch Process - Data Summary Base Tables',
@step_id = 5,
@on_success_action = 3 ,
@on_fail_action = 3
GO