Select from following answers:- Attaching the job to a schedule
- In response to an alert
- By executing the sp_start_job stored procedure
- any of these options
- All Above
We can use all of the above options.
The below is the syntax for 3rd options,
EXEC msdb..sp_start_job
[@job_name] or [@job_id ]
[,@error_flag ]
[,@server_name]
[,@step_name ]
[,@output_flag ]
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator