Create a script to update subscriber statistics on server

[outsmain]

• Rename stored procedure from "FILL_LOSS_SUBS_LOG" to "PROC_FILL_LOSS_SUBS_LOG" and create it on a development server

• Create a YII console application for calling this stored procedure. It's parameters are

  • start_date (mandatory)
  • end_date (mandatory)
  • ip_addr (optional)
  • service_type (optional)
  • step (optional, default value is 60 minutes)
  • tolerance (optional, default value is 30 minutes)

  If user not provide optional parameters then

  • It will use a default values
  • If it not has a default value then pass value "NULL" to a stored procedure, instead
• Create a shell script (batch file on Windows) to call this console application in directory "bin" in your home directory
• Write an example instruction to call this shell script in directory "tmp" in your home directory