I'm trying to set up an hourly job that would fetch records using MQ Series. I was wondering if there is an advantage to schedule this job through a Stored Procedure in SQL Server over a Scheduled Task through NT Services or are there better ways to schedule these kind of jobs? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Stored Procedure vs Scheduled task
- Thread starter YL5956
- Start date
Difference between those 2 are the user account.
With the Scheduled Task you will need to set a Domain Account, whereas the Job, it will use the sql agent account, which could be also a domain account.
Both are doing the same. As for me, I rather use the job, but it depends on people.
Kim
With the Scheduled Task you will need to set a Domain Account, whereas the Job, it will use the sql agent account, which could be also a domain account.
Both are doing the same. As for me, I rather use the job, but it depends on people.
Kim
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question