SQL Rookie
Reputation: 19
SQL Job Manual Run vs Scheduled RUN
I am having a situation with the scheduled job running longer when it runs on scheduled time, but runs absolutely fine when executing manually.
The job is basically for creating the csv file using SSIS and I am using SSIS catalog to execute the package
I ran the job manually and it took 10 min to finish and when scheduled it takes almost 75 min
Upvotes: 0
Views: 81
Answers (0)
Related Questions
- How to concatenate text from multiple rows into a single text string in SQL Server
- How to return only the Date from a SQL Server DateTime datatype
- How to add a column with a default value to an existing table in SQL Server?
- Check if table exists in SQL Server
- How do I UPDATE from a SELECT in SQL Server?
- How to check if a column exists in a SQL Server table
- How do I perform an IF...THEN in an SQL SELECT?
- How can I do an UPDATE statement with JOIN in SQL Server?
- LEFT JOIN vs. LEFT OUTER JOIN in SQL Server