• Adam Thurgar

SQL Server Agent Tokens

One of the good things about working with SQL Server is that you are constantly learning. It wasn't until very recently that I learnt about SQL Server Agent tokens. They are like environment variables that can be used within a job step. Books Online states as "Using tokens when you write your job steps gives you the same flexibility that variables provide when you write software programs. After you insert a token in a job step script, SQL Server Agent replaces the token at run time, before the job step is executed by the Transact-SQL subsystem."

For example: I found this very handy for writing job output to a file in the log directory using the SQLLOGDIR token.


Read more



Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t