Automic Workload Automation

 View Only

 How to send SQL VAR OBJECT result as excel sheet attachment through email

Abhay Chauhan's profile image
Abhay Chauhan posted May 18, 2023 10:31 AM

Dear experts,

I have created a Oracle SQL VAR OBJECT to detect long-running jobs. I want to schedule this jobs for weekly run and get the result in a spreadsheet through email. I know how to send SQL VAR OBJECT result through CALL NOTIFICATION object printing the result (few rows) in the email body but I do not know how to get and send the SQL query result (more than 100 rows)  into a spreadsheet through email. Can someone help me here

Kindly help me here
Thanks in advance

Thanks
Abhay Chauhan

marc broussard's profile image
marc broussard

hello

maybe using this kind of command:

:  SET &RC2# = SEND_MAIL('people@domain.com',,'OBJET',' body of the mail','\\path_to_your_file\FIC_CSV','agent_oa','LOGIN.DEFAUT')