as in going into sql agent, adding a new job and manuallly setting up each step :)
Printable View
as in going into sql agent, adding a new job and manuallly setting up each step :)
No, I was just running the entire package from the agent....it failed on the step I mentioned. I ran the step from my desktop and it ran beautifully! Should I reschedule the package or break the package into steps and then reschedule? Why would that make a difference? The code hasn't changed. :confused:
the only thing I can think of trying, is to make a new package from scratch on hte server instead of your desktop.
I'll give it a try! Thanks!:)
np katie :)
Do I detect useful work going on in here? :eek:
I'm so ashamed of myself, Parksie. Will you ever forgive me? I promise I won't let it happen again!
Ian, I rescheduled it and it's running now....I'll let you know whether it worked or not!
:D
Katie -- I might...but first it's off to the spanking room for you ;)
Yay!!!!!!!!
I mean.....I'll behave.
Where's the fun in that? :p
I didn't say I'd behave well.........I just said I'd behave!;) :p
;) :eek: :D
Have I missed a spanking!
Sadly, yes. Although I was delivering it (in my guise as the guy in my sig :p) to Katie, if you want one from her you'll have to "take it up" with her....
Yeah, but I could always be bad again if you wanted!!! :cool:
I've only just recovered from the last time! :p
Have I missed all the fun?
Hi Vicky!
What fun?
*quickly pulls up trousers*