Home Dashboard Directory Help
Search

Instance_Id token for SQL Server Agent by admin_veratech


Status: 

Closed
 as Won't Fix Help for as Won't Fix


1
0
Sign in
to vote
Type: Suggestion
ID: 794080
Opened: 7/16/2013 1:34:13 AM
Access Restriction: Public
0
Workaround(s)
view

Description

SQL Server Agent jobs can use tokens to get metadata about the job. For example, a running job can get its own job id from $(ESCAPE_NONE(JOBID)). There is also a token for Step Id.

However, there isn't a token for Instance_Id (ie select [instance_id] from [msdb].[dbo].[sysjobhistory]). I would find this very helpful if you could implement this.
Details
Sign in to post a comment.
Posted by Microsoft on 7/26/2013 at 1:29 PM
Hello Veratech. After carefully evaluating all of the suggestion items in our pipeline, we are closing items that we will not implement in the near future due to current higher priority items. We will re-evaluate the closed suggestions again in the future based on the product roadmap. Thanks again for providing the product suggestion and continued support for our product.

-Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Sign in to post a workaround.