-
how to run procedure based on day
I have a main procedure called SP_MAIN, which will call the below procedures for execution everyday.
SP_ACCT
SP_CONSOLE
SP_CUST
SP_RATE
SP_BAL
SP_PRO
SP_CDT
I need only execute SP_RATE on every Tuesday on third week of the month.
How to execute a procedure based on a specific day?
All these procedure has dependencies, I can't take out SP_RATE from SP_MAIN as a standalone procedure. How could I include a function within the SP_MAIN to have SP_RATE only run on every Tuesday on third week of the month?
Appreciate any suggestion given.
thanks
best regards,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|