Full time position; 90 to 95K depending on experience; Good bonus based on performance.

Normally in the six figures. Any way, most of Database Managers do make six figures.

one minute after I added new schedule, it set the next run date and next run time correct for both schedules. But, still I do not understand why it does...

I tried changing the schedule several times and it is not updating sysjobschedules. I created a new schedule (keeping the original in place) for the same job. Sysjobschedules show 0...

The job runs fine if I start it manually. It is just that the schedule does not trigger the job if you change the schedule say from 11:00AM to 11:05AM....

Job is enabled and Schedule is enabled.

SQL Agent service account or password is not changed. Nothing is changed.

The job is to run SSIS package. Thanks.

Schedule was changed yesterday. The next run date and next run time is not updated till now. SQL Agent is running. Where is the setting (20 minutes) for sysjobschedule refresh?...

I am having the same problem in Sql 2005 Enterprise RTM.

Whenever I make a change to my schedule (enable or disable schedule, change frequency, time etc), the next run date...

I have been in a situation like this before. It was not for any SOX or HIPAA reasons. It was just so my Boss has full control over everything even...

Somebody please reply. Waiting for your reply.

Try using trace flags and then look into your error log. You can use -T1204 and -T3605 as startup parameter.

If it is within a session, you can use DBCC...

Check this out. Free book on SQL DTS:

http://www.haidongji.com/2006/04/02/do-you-want-a-free-book-on-sql-server-integration-services/

How can I pick up a parameter value from an ini file

I am having the same problem and would like to know. Thanks.

Finally, I took the parameter as it is and declared local variables to each of those parameters and assigned the parameter values to these local variables in my SP. Then...