Allow SP_START_JOB to populate SQL Agent tokens - by Brian Callaghan

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


2
0
Sign in
to vote
ID 784988 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 4/18/2013 1:15:37 AM
Access Restriction Public

Description

It would be great if we could pass data to an SQL job. The Altert systems uses tokens which allow us to make descissions based on alert data. how about expanding the tokens to sp_start_job as an XML parameter so we can pass an xml string to a job.

The enhancements to SQL server have been great in the past 10 years. The SQL agent could really do with some attention. 
Sign in to post a comment.
Posted by Microsoft on 6/13/2013 at 1:26 PM
Hi Brian,

Thank you for suggesting this change. Unfortunately, I would like to let you know that we won't be able to take it into the upcoming SQL Server release. We might reconsider it for one of the future releases.

Thank you again for the feedback. We rely on customers' input a lot in improving our products and appreciate it hugely.

Evgeny Krivosheev
SQL Server Program Manager