Automating job scripts

Question

Post reply

Automating job scripts

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 1

dave-dj (6/3/2010)
the problem is I get - variable .... not defined as a scalar value.

post your script

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 2

Job_ID is not an int. You have to use uniqueidentifier or char / varchar data types for your variable.

EDIT: And yes, what you want to do is possible. Just adjust your expectations of how to deal with the data type and your code should work.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

dave-dj SSChampion Points: 11297 More actions · Answer 3

guys,

thanks for posting - I think i've now found the cause of the problem which seemed related to how I set the variable.

_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 4

Glad we could help. Let us know if you need anything else.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.