Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 I just can't find... (sql server agent tags)

Author  Topic 

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2006-03-23 : 17:20:23
The meta data tags that one can specify for sql server agent jobs.
Where are they documented?

Clarification:
When running jobs, one can write things like [SERVER], [JOBNAME]..
and the tags will get substituted with the appropriate text by the agent.

Ring a bell for anyone?

rockmoose

SQLServerDBA_Dan
Aged Yak Warrior

752 Posts

Posted - 2006-03-24 : 13:06:56
quote:
Originally posted by rockmoose

The meta data tags that one can specify for sql server agent jobs.
Where are they documented?

Clarification:
When running jobs, one can write things like [SERVER], [JOBNAME]..
and the tags will get substituted with the appropriate text by the agent.

Ring a bell for anyone?

rockmoose




You're talking about tokens. Like: [SQLDIR], [LOGIN], [PSWD], or [SRVR].

You can find info on those here: http://www.sqldev.net/sqlagent/SQLAgentStepTokens.htm



Daniel, MCP, A+
SQL Server DBA
www.dallasteam.com
Go to Top of Page

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2006-03-24 : 18:24:26
Thank you very much Daniel!
I looked and looked, and googled and googled.
No luck since I couldn't pinpoint the word "token".

in BOL, it's under the documentation for sp_add_job_step, oh well, didn't look there.

Anyhow, they didn't turn out to be so useful after all :(


rockmoose
Go to Top of Page
   

- Advertisement -