can i have steps based answer to my query
we want to run stored procedure as job on regular interval using power shell style formatting output to file.
Procedure contents: simple select query
Some checking did: when we are calling procedure using invoke-sqlcmd -q "exec xxx" it work perfect from power shell Stuck at: need to know how to call from job section using power shell to run like invoking from power shell