Loading

sql server agent job

GOPIKRISHNA TIRUVEEDHULA

7y1.3k

the following job "Move File" is working fine.

The problem is in the morning time (we checked) below 10Am it showing error.After that its working fine.

give me the solution for that? is there any datestring issue?

move D:\TPIL_DASHBOARD_SALES_SERIAL_EXTRACTS\TPCO_Sales_Orders_Extract.txt d:\TPIL_DASHBOARD_SALES_DB\processed\TPCO_Sales_Orders_Extract_%date:~-4%_%date:~3,2%_%date:~0,2%__%time:~0,2%_%time:~3,2%_%time:~6,2%.txt

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Shah7y ago
what does this give you in final value?
d:\TPIL_DASHBOARD_SALES_DB\processed\TPCO_Sales_Orders_Extract_%date:~-4%_%date:~3,2%_%date:~0,2%__%time:~0,2%_%time:~3,2%_%time:~6,2%.txt

Did you try evaluating this by placing time which is before 10 am like 9 am or 9.30 am

Please keep in mind the time will be considered of the server on which database is hosted and not the time of your developer machine.