Can we create Jobs in Sql Server?
Why not? Look at SQLServer Agent.
|||Yes, you can have.
For example: a job that responsible to run a DTS (or SSIS) package on a specifc time in a day to do a task (e.g. execute stored procedure or take backup).
Note: Any scheduled thing is SQL Server requre the SqlAgent service to be started and running.
Good luck.
|||You can create jobs in sqlserver in sqlserver agent in sqlserver 2005.
No comments:
Post a Comment