SQL Server Agent jobs -


some related questions sql server agent jobs in microsoft sql server 2014.

  1. is $(sqllogdir) appropriate place job step output files
  2. is valid create stored procedures in 'master' or 'msdb' database call job step instead of having sql directly in job step
  3. what proper location powershell scripts used in job step? in c:\pf\...\mssql\jobs, (sibling directory data)? best way specify directory, $(sqllogdir)\..\jobs

thank you


Comments

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

javascript - jQuery date picker - Disable dates after the selection from the first date picker -