JDBC Sender OS Command

Hi All,

I want to know where the operating system command runs when used in jdbc sender adapter , In PI or in the database after executing the sql queries? I am wondering if i can use a Stored procedure through a script in database. Any help appreciated .And forgive me for my ignorance Thanks.