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.
| Author |
Topic |
|
cwalston
Starting Member
25 Posts |
 Posted - 2007-08-27 : 09:23:37
|
Hi All, Does anyone know off the top of their heads if you use the [DATE] variable inside a job step that runs into the next day, if the value changes?I am using it to copy dumps (with a date/timestamp in the names) from one environment to the other at the end of the day and not all the files get copied. I do not get an error for the job...just missing files. This was one theory and I figured I would ask the experts!  Thanks!! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-27 : 22:10:22
|
| What's file naming convension and your code? |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-04 : 16:09:03
|
| you mean getdate()?works great... unless you don't format the date and you get spaces and : which actually truncates your filename or aborts it somewhat... since it's a job, you don't get the usual user interaction prompts or messages so sql agent doesn't know there was an actual error occuringHTH--------------------keeping it simple... |
|
|
|
|
|
|
Job Step Variable [DATE]