locked
sql server agent job RRS feed

  • Question

  • 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.could anybody provide batch file for this

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

    Thursday, October 8, 2015 6:31 PM

Answers

  • Hi Vamsivaliveti,

    Just as Arthur said, SQL Server Agent job and SSIS are different. There is no need to compare them. A job is a specified series of actions that SQL Server Agent performs. Use jobs to define an administrative task that can be run one or more times and monitored for success or failure. A job can run on one local server or on multiple remote servers. SSIS is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.

    I’m confused by what’s the meaning of “schedule sql server agent Job using Tidal”, do you want to schedule a SQL Server Agent job in Tidal? If I understand correctly, the Tidal named Tidal Enterprise Scheduler, it is also a scheduler like SQL Server Agent job. Why did you need to schedule a SQL Server Agent job with Tidal?

    If you need to schedule a SSIS package using Tidal, you should create a batch file to execute the SSIS package, then use Tidal to schedule the batch file. The following document is for your reference:
    http://www.cisco.com/c/en/us/td/docs/net_mgmt/datacenter_mgmt/Tidal_Enterprise_Scheduler/6-2/tutorial_guides/windows/Cisco_TES_6-2_Tutorial_Windows/Creating_Your_First_Job.html

    Thanks,
    Katherine Xiong


    Katherine Xiong
    TechNet Community Support

    Friday, October 9, 2015 7:23 AM

All replies

  • Hi Vamsivaliveti,

    Re #1: Those you cannot compare. SQL Server Agent job is the means of workload execution whereas SSIS is ETL

    Re #2: Script a sample SQL Agent job you created with the SSIS package step (if needed) manually http://www.sqlmatters.com/Articles/Scripting%20all%20Agent%20Jobs%20Using%20SQL%20Server%20Management%20Studio%20%28SSMS%29.aspx then generate the one you need programmatically, Tidal would need to open a connection up to the target SQL Server instance and deploy it. How it can seek for at the Todal's forum.


    Arthur

    MyBlog


    Twitter

    Thursday, October 8, 2015 6:40 PM
  • Thanks alot for the Input.Point 2 is not clear to me You mean to say create a script for  SQL Agent job and schedule it from Tidal.Could you please elaborate on this.How SSIS is relates here since you mentioned both are different
    Friday, October 9, 2015 3:21 AM
  • Hi Vamsivaliveti,

    Just as Arthur said, SQL Server Agent job and SSIS are different. There is no need to compare them. A job is a specified series of actions that SQL Server Agent performs. Use jobs to define an administrative task that can be run one or more times and monitored for success or failure. A job can run on one local server or on multiple remote servers. SSIS is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.

    I’m confused by what’s the meaning of “schedule sql server agent Job using Tidal”, do you want to schedule a SQL Server Agent job in Tidal? If I understand correctly, the Tidal named Tidal Enterprise Scheduler, it is also a scheduler like SQL Server Agent job. Why did you need to schedule a SQL Server Agent job with Tidal?

    If you need to schedule a SSIS package using Tidal, you should create a batch file to execute the SSIS package, then use Tidal to schedule the batch file. The following document is for your reference:
    http://www.cisco.com/c/en/us/td/docs/net_mgmt/datacenter_mgmt/Tidal_Enterprise_Scheduler/6-2/tutorial_guides/windows/Cisco_TES_6-2_Tutorial_Windows/Creating_Your_First_Job.html

    Thanks,
    Katherine Xiong


    Katherine Xiong
    TechNet Community Support

    Friday, October 9, 2015 7:23 AM