@Amatya Sir,
By task did you mean SSIS Task or Database Task?
If you mean the first one, then a
SSIS task is to make the flow happen between the source and the destination. It has multiple task like Dataflow task,Data Preparation Tasks,Workflow Tasks etc. Once the SSIS tasks are made properly then we deploy the SSIS package and one of the way to schedule the SSIS package is through
SQL Job which is a series of operations perform the SQL Server agent.
If you mean
Database task , then it involves a series of activities on the database like backup, restore, detach/attach a database, shrink database, generate DDL/DML scripts for the database, Import and Export wizard for data export/import etc. It does not have any thing to do with SQL Job. However, we can always create a maintenance plan for that.
Hope this helps.
--
Thanks & Regards,
RNA Team
Amatya, if this helps please login to Mark As Answer. | Alert Moderator