Salutations. I am hosting Coresight and AF on the same W2K12R2 server using SQL Server 2014 Standard Edition. I would prefer adding the Coresight backups to the AF (PIFD database) job or scheduling a second job if needed. I do not want to use a Windows scheduled task with a sql command file if I can avoid it.
Page 75 of the PI Coresight 2016 R2 Installation and Administration Guide says
"You can use the following command to run the backup: sqlcmd -S SQLINSTANCE -d PI Coresight Database -Q "EXEC dbo.usp_backup @outpath = N'', @allwaysfullbackup =1;" -E
The stored procedures are in the PIFD database, not the Coresight database. How can I create a job in SQL Server to do this?