Hi.
The site I am working at uses SQL2016 Std Ed and does not enable the SQL Agent. Scheduled tasks such as backups etc are run centrally from a 3rd party app.
I would like to set up transactional replication.
Most of the SQL Agent jobs that are created are essentially T-SQL tasks, using the TSQL subsystem in SQL Agent to issue EXEC <sproc> commands. However, 3 jobs - the LogReader Agent, Snapshot Agent and Distribution Agent - use the 'LogReader', 'Snapshot' and 'Distribution' subsystems. So these are not simply issuing EXEC <sproc> commands. For example:
the Snapshot Agent Job has 3 steps - steps 1 and 3 use TSQL but step 2 uses the Snapshot subsystem:
Step 1
Name: Snapshot Agent startup message.
Subsystem: TSQL
Command: sp_MSadd_snapshot_history @perfmon_increment = 0, @agent_id = 1, @runstatus = 1, @comments = N'Starting agent.'
Step 2
Name: Run agent.
Subsystem: Snapshot
Command: -Publisher [SQL01] -PublisherDB [pubdb] -Distributor [SQL02] -Publication [mypub] -DistributorSecurityMode 1
Step 3
Name: Detect nonlogged agent shutdown.
Subsystem: TSQL
Command: sp_MSdetect_nonlogged_shutdown @subsystem = 'Snapshot', @agent_id = 1
My question is: without enabling the SQL Server Agent (to be clear: not just disabling the jobs, but disabling the SQL Agent service itself after the initial setup) is it possible to run these replication tasks? Perhaps using PowerShell etc?
Many thanks for any help!