GETDATE() in a T-SQL Job Step Command

Question

I can't seem to get the GETDATE() syntax to work in a Job Step of type Transact-Sql Script. I put in the command as:

execute insertMostRecentUpdate 
@Data='Data', 
@Date=GETDATE()-1

But I get an "incorrect syntax near ')'" error when parsing or trying to run it. Any thoughts?

Answer 1

Try this:

DECLARE @date DATETIME;
SET @date = GETDATE()-1;

execute insertMostRecentUpdate 
@Data='Data', 
@Date=@date;

You cannot use GETDATE() as inline-function while calling a procedure.

Greets Flo

Answer 2

You could try something like this,

declare @date date
set @date = GETDATE()-1

exec insertMostRecentUpdate 'data',@date

Suprise me when i ran, thought i should compile, but I think its because you are passing a function into your proc