Tidal with sql server agent job

[vamsivaliveti.edu1]

I am very new to MS SQl-server and Tidal.Input is really apreciated.

1)what is difference between SSIS  and sql server agent Job.Is both are same?
2)I need to schedule sql server agent Job using Tidal.

sqlserver agent example-http://sqlserverscribbles.com/2013/06/08/how-to-create-sql-server-agent-jobs/

[Derrick Au]

Hi vamsivaliveti.edu1

Please check out this link, http://www.jamesserra.com/archive/2014/07/sql-server-agent-job-steps-vs-ssis/

To schedule a sql job in Tidal, can you check to see if your Tidal Master is licensed for MsSql adapter? To verify, Click on Activities -> Register License

BR,

Derrick Au

[rocketscientist1]

SSIS packages can be run from a normal windows agent.

If you wish to run stored procedures within the MSSQL framework, you can use them via the MSSQL Adapter.  

Price point for Windows Agent is around $500 - $1000

Price point for MSSQL Adapter is north of $1500