Hopefully I’m in the correct forum for this question. I’m trying to create a Scheduled Job in Toad 10.6.1.3 which executes a stored procedure. The procedure is simple and runs fine manually. I’m having real difficulty creating the scheduled job that would spawn it. It seems I can’t get the Start Date in the correct format. I’ve tried many things…SYSDATE, SYSTIMESTAMP along with various other hard dates but I’m getting different errors for each. For example: using SYSDATE as the Start Date I get…“ORA-01841: (full) year must be between -4713 and +9999, and not be 0 ORA-06512: at line 2”
I’ve searched in this forum along with on the internet but haven’t found anything that really helps. Can someone please assist?